Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

MS Excel: Generate a unique list of entries in a column

No comments
Just before lunch time, my boss sent me an excel document that contains list of computer models. Here requirement is to get only the unique entries from the huge list. How did I get it?

Here is how you select unique entries from a list in a column.

1. Select the column you want to filter.
2. Go to Data menu, click filter and then Advanced Filter.
3. From the Advanced Filter dialog, tick the "Unique records only" checkbox. (If you want to copy the filtered list on another location, choose Copy to another location. then put the column label where you want it to appear)

Generate a unique list of entries in a column in Excel

4. Click OK.

The list should now display only unique data.

No comments :

Post a Comment