Please help: Trying to return 1st unique value of items in a list

J

jhburris

I've got a list of values, many of which are duplicates. How do I creat
a list of just the first instance of each unique value
 
P

Peo Sjoblom

Look at data>filter>advanced filter, use copy to another location and unique
records only
 
R

Ron Rosenfeld

I've got a list of values, many of which are duplicates. How do I create
a list of just the first instance of each unique value?
Click to expand...

Search for "unique" in HELP.

Data/Filter/Advanced
Check your action option
Fill in the List Range
Leave the Criteria range blank
Select "unique records only"


--ron
 
J

jhburris

Thanks! The DUPLICATE tip helped me out. I wasn't able to selec
Advanced Filter; it's greyed out and I can't find out why. Don't nee
it right now, but it sure would be nice to know if I needed it in th
future.

Thanks again
 
Top