return one value from list
 

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

return one value from list
 

You can try Bvan's solution found here.

http://www.ozgrid.com/forum/showthread.php?t=28989


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=549094

return one value from list
 

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

for a formula solution see

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


same formula can be found here

http://www.nwexcelsolutions.com/adva...ction_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


"ChadTarget" wrote in message
...
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