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

  • Thread starter Thread starter jhburris
  • Start date Start date
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
 
Look at data>filter>advanced filter, use copy to another location and unique
records only
 
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
 
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
 
You must log in or register to reply here.

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

Reverse Unique Values 1
Unique values in an array. 2
Duplicates Question 3
Frequency of items in a huge range 3
find unique records 8
Data Validation - List of unique values 2
Filter for Unique Values not working 1
Sumif using Values, but returning text or values 1

Back
Top