| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string compare with wildcards
Hi folks,
may be a stupid question, I want to use the following formula to fill a cell: {=SUM((D3:D113="STRING")*B3:B113)} which works fine, but accepting all kinds of "STRING*", like: "STRING1", "STRING2222",... is there an easy way ??? thanx in advance marcus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare string | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
| Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
Linear Mode
