Is there a formula or function that will return unique values in a column only. I have 1 column with a large data set with many duplicate items and i need to know only the items that are showing up. i have tried advanced filter but i havent had good luck. any ideas?
Return Unique Values Only
-
-
Re: Return Unique Values Only
Hi,
In what way did the Advanced Filter not work? It sounds like the ideal solution
Anyway, you may also be interested in the duplicates conditional formatting section at http://www.cpearson.com/Excel/Duplicates.aspx
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!