Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Match Part of Text Within Cell, Then Blank
Hi,
I'm trying to create an if statement, with no luck. Col A Col B Col F Apples value nanas Bannanas wackos Coconuts value Formulas in Col B: If any of the text in Col A matches another cell with "nanas" or "wackos" in it (in this case F1 and F2), then leave the cell blank, otherwise X. X being another formula that returns some random value. Essentially I'm trying to create a reference list in column F, for as many references as possible, maybe up to 20, so if any of the values in col A match any of the text strings in column F, it leaves the cell blank. I tried, couldn't do it. Saw something with =Countif(A1,"*nanas*") but couldn't adjust it. Thanks very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to get text from part of a cell | Excel Worksheet Functions | |||
Can you keep text from one cell showing over the next cell? | Excel Discussion (Misc queries) | |||
How do I delete part of a text string in every cell it appears in | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
match cell text with text in formula | Excel Worksheet Functions |