Assuming that your first Blue entry is in A2, put this formula in another
cell on row 2
=COUNTIF(A$2:A2,A2)
and fill the formula down the list. At the 1st entry for any value in
column A the value will be 1. Then you filter on that column to display
entries with a value of 1 and copy the displayed information to another
sheet, which will give you a list of unique entries.
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.