return one value from list

C

ChadTarget

I have a form that a user inputs different categories using drop down boxes.
I need to be able to summarize that data. Is there anyway to get the single
value from the list. For example, someone could choose the same category
twice, but I only want it to be pulled into my list once. I'm not sure if I
need a match or index or if there are any formulas specific for this kind of
question.

EX)
Categories
Pillows
Pillows
Sheets
Tablecloth
Pillows

I would like to lookup off of the above entries and create a list that would
read

Pillows
Sheets
Tableclothes

Thanks
 
P

Peo Sjoblom

Make sure you have a header, select the range, do data>filter>advanced filer
and select copy to another location and unique entries only

for a formula solution see

http://nwexcelsolutions.com/Download/Sort_alphabetical_and_then_extract_unique_records.xls


same formula can be found here

http://www.nwexcelsolutions.com/advanced_function_page.htm

number 1 the second formula

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top