Filter out distinct items

K

Kenneth

Is there any quick way to get a distinct list of unsorted (or sorted if
necessary) column with repeated values?
Thanks.
 
S

summergs

Probably the easiest way is to highlight the column you want to do th
distinct sort on and go to the Data menu, Data -> Filter -> Advance
Filter, choose your list range and just be sure to check the "Uniqu
records only" box at the bottom of the window
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top