Make list of unique values

**Roeltje** · 10-12-2011, 05:57 AM

Hi all,

Is it possible to make a list in excel with unique values?
I.e.:
[names]
Name A
Name B
Name B
Name A
Name C
Name D

In another sheet, i want a list of unique names:
Name A
Name B
Name C
Name D

Is this possible?

**tom1977** · 10-12-2011, 06:00 AM

use advance filter in ex 2003 or remove duplicates in ex 2007

regards

**Roeltje** · 10-12-2011, 06:00 AM

I want to do this by function, so it goes automaticly.

**tom1977** · 10-12-2011, 06:44 AM

see atachment

regards

**Roeltje** · 10-12-2011, 06:58 AM

Thanks, i gonna try Tom!

**Venie711** · 10-12-2011, 08:59 AM

My boss wants me to make a spreadsheet to include data such as:

11-5
2-5
and so on. But I am having difficulty and suggestions?

**NBVC** · 10-12-2011, 09:03 AM

Venie711,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.