| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I find a value from one cell in a char string in another?
I am trying to figure out how to search for a specific alphanumeric value
from a cell in a character string in another cell. Does anyone know how to do this, or if it can be done via a Excel command? For instance, the below works fine if I only want to find an exact match for the values within column D for that in cell H3, but I do not know how to find the same value from H3 if the values in column D contain a match mixed in a character string. Any help would be greatly appreciated! =SUM(IF(('Input Form'!C$4:C$549=$G$3)*('Input Form'!D$4:D$549=$H$3)*('Input Form'!R$4:R$549<=$A126)*(NOT(ISBLANK('Input Form'!R$4:R$549))),1,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| How to retrieve certain char within a string? | Excel Discussion (Misc queries) | |||
| How to verify the first char of the string in excel? | Excel Discussion (Misc queries) | |||
| How do i get the last position of a char (space) in a string? | Excel Worksheet Functions | |||
| string/char CONTAINS function? | Excel Worksheet Functions | |||
Threaded Mode
