Wow! When it rains it pours! More Excel tricks 🙂
This one is also duplicate related (can you guess what I do for a living? 🙂 ) Another super easy trick to remove duplicates (no formulas needed)
- Select the column (not row – you may need to do a transpose)
- Go to the data tab
- Click remove duplicates
Excel like a boss!