Extracting all matches

  • Thread starter Thread starter Blue Max
  • Start date Start date
B

Blue Max

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?
 
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

************
 
Back
Top