Removing duplicates in Excel

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)

  1. Select the column (not row – you may need to do a transpose)
  2. Go to the data tab
  3. Click remove duplicates
  4. Done!

Excel like a boss!