| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for searching for a text string
I have a table where each cell contains a string of various alphanumeric
codes. For example: KB / S596-19 RM / S243-59 VB / I1997-1 KB / GEN SV / GEN I want to write a formula to count 1 if the cell is populated (not all cells are), but count 0 if the cell contains 'GEN'. I've tried this: =IF(AND(B4<"",B4<"*GEN*"),1,0) But the "*GEN*" portion of this formula does not work. Any suggestions? KellyB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
| find text in a string formula | Excel Worksheet Functions | |||
| Return a formula as text string to a cell | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
