I got this great formula from Exceluser.com (thank you Charley Kyd) to do multi search criteria.
Sheet1
<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 97px"> <col style="WIDTH: 64px"></colgroup> <tbody>
</tbody>
<tbody>
</tbody>
I'm trying to apply this formula by using a range B1:B4 without copying down the formula for each row in C1:C4. I would like to use a small(if function if possible so I can get multiple matches.
The formula would be something like this:
=SUMPRODUCT(NOT(ISERR(SEARCH({"smith","paul","greg"},B1:B4)))*{1,2,4})=7
I'm getting an error message when I try and do this.
Is there a way to do this?
Excel tables to the web >> Excel Jeanie HTML 4
Sheet1
B | C | |
1 | jerry paul | FALSE |
2 | rand grere | FALSE |
3 | paul smith | FALSE |
4 | greg paul smith | TRUE |
<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 97px"> <col style="WIDTH: 64px"></colgroup> <tbody>
</tbody>
Spreadsheet Formulas | ||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
I'm trying to apply this formula by using a range B1:B4 without copying down the formula for each row in C1:C4. I would like to use a small(if function if possible so I can get multiple matches.
The formula would be something like this:
=SUMPRODUCT(NOT(ISERR(SEARCH({"smith","paul","greg"},B1:B4)))*{1,2,4})=7
I'm getting an error message when I try and do this.
Is there a way to do this?
Excel tables to the web >> Excel Jeanie HTML 4