Obtain All Items In A List

Dell Studio 1535
June 30, 2010 at 13:40:31
Specs: Microsoft Windows Vista Home Premium, 2 GHz / 3061 MB
Hi,
I have a long list of names, repeated, and with excel I want to obtain a set of all the posible names that are found in that list. any help with a formula on how to achieve this

thanx


See More: Obtain All Items In A List

Report •


#1
June 30, 2010 at 13:54:35
When posting in a help forum, it's best to use a subject line that is relevant to the contents of the post.

If everyone posted with a subject line of "Microsoft Excel" we wouldn't be able to tell one question from another.

I've fixed the subject for this thread.

DerbyDad03
Excel Forum Moderator


Report •

#2
June 30, 2010 at 13:57:18
Select your list and click on Data...Filter...Advanced Filter.

In that dialog box, you can choose the options to:

1 - Copy to another location
2 - Unique records only

By choosing those 2 options, you will get a list of each unique item from your longer list.

Let us know if you need any further help.


Report •

#3
June 30, 2010 at 15:42:06
Thanx Derbydad,

It worked, u saved a lot of time.
take care


Report •

Related Solutions

#4
June 30, 2010 at 18:34:17
Glad I could help...

Report •

Ask Question