Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup a value in a list & return multiple corresponding values | Excel Worksheet Functions | |||
Drop down list to return row number? | Excel Discussion (Misc queries) | |||
Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
return a list | Excel Worksheet Functions | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions |