Function to filter duplicate values

R

Ryan Poth

Someone asked me yesterday if I knew of an Excel function
that would take as it's argument a list of values and
return a list consisting of those values with duplicates
removed. So if I passed a range that looked like...
apple
banana
apple
pear
pear
....it would return...
apple
banana
pear

I have written a custom function for him in VBA, but it
started me thinking that Excel must have a function that
does this already, but I don't know of one. Does anybody
else?
 

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

Similar Threads

Create list of unique entries for use in validation 5
translating countifs function to Excel 2003 4
Match values in more than one column 6
Validation list based on criteria 0
Stripe out duplicate data 5
Index function 4
How to make list of Items displayed in AutoFilter? Any Function? 9
Lookup value with items in different rows 5

Top