Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of wildcards
Does anyone know how to use wildcards properly in a formula. For example
(=SUMPRODUCT((A1:A4="6-*")*(C1:C4="ok")*(B1:B4="c-25")). Where "6-*" would be anywhere the entry in cells A1:A4 begins with the number 6. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use replace to edit a formula with wildcards | Excel Worksheet Functions | |||
Can conditional sum use wildcards in the formula? | Excel Worksheet Functions | |||
Wildcards in Functions | Excel Worksheet Functions | |||
Wildcards in Functions | Excel Worksheet Functions | |||
vlookup & wildcards | Excel Worksheet Functions |