Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting all matches
We need to find all the cells in a column that match a certain criteria and
then extract the associated value in a second column. Both the lookup column and the extraction column are text. SUMIF( ) might work, but we also want to know if there is a lookup function that can find more than one value, if the criteria is met. Finally, regardless of the method used above, is there a way to save the resulting values (text) as an array or in a similar format whereby the separate values (text) could be concatenated or otherwise manipulated? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting all matches
Hi,
You may try my solution here - http://office.microsoft.com/en-us/ex...CL100570551033 -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Blue Max" wrote in message ... We need to find all the cells in a column that match a certain criteria and then extract the associated value in a second column. Both the lookup column and the extraction column are text. SUMIF( ) might work, but we also want to know if there is a lookup function that can find more than one value, if the criteria is met. Finally, regardless of the method used above, is there a way to save the resulting values (text) as an array or in a similar format whereby the separate values (text) could be concatenated or otherwise manipulated? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting all matches
Thank you, Ashish. The recommended article is wonderful, but the printout
(or saved .PDF) cuts off the longer formula samples. Is there a way to save the article to hard disk so that the example formulas can be fully displayed? Thanks, Richard ************ "Ashish Mathur" wrote in message ... Hi, You may try my solution here - http://office.microsoft.com/en-us/ex...CL100570551033 -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Blue Max" wrote in message ... We need to find all the cells in a column that match a certain criteria and then extract the associated value in a second column. Both the lookup column and the extraction column are text. SUMIF( ) might work, but we also want to know if there is a lookup function that can find more than one value, if the criteria is met. Finally, regardless of the method used above, is there a way to save the resulting values (text) as an array or in a similar format whereby the separate values (text) could be concatenated or otherwise manipulated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Text String that matches with list | Excel Worksheet Functions | |||
Finding matches ( | Excel Discussion (Misc queries) | |||
Data Matches | Excel Discussion (Misc queries) | |||
matches | Excel Discussion (Misc queries) | |||
matches | Excel Discussion (Misc queries) |