Need a unique list from repeated list

**evanwm** · 04-11-2013, 01:04 PM

I have a column full of 4 different names that are repeated different amounts of times in random order.

John
Sally
Sally
Steve
John
Betsy
Betsy
Sally

I want to make a list of just the four unique names, in any order.

John
Sally
Steve
Betsy

Is there any function to automate this? Perhaps anything to filter duplicates?
I know I can use the Advanced Filter, but I'd like to have it automated.

**evanwm** · 04-11-2013, 01:09 PM

I'd also like to have both columns. Replacing the first column containing the repeated names isn't an option.

**Kevin UK** · 04-11-2013, 01:49 PM

Hi evanwm

Assuming your data is in A2: A9, column header in A1. In B2 and copy down.

Formula:

Please Login or Register  to view this content.

Now I am not sure, if "Excel 2008" has the iferror function. Is that for a Mac!

You might have to wrap in a IF & ISERROR, to error trap.

**evanwm** · 04-11-2013, 07:42 PM

Fantastic! Thanks for the help. I developed an if(countif( function, but yours is considerably better. There are some frequent holes in the data that your function reduces to just one hole. Manageable for now.