| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making the AND function look at only part of a cell entry
I am trying to identify different conditions that might exist with data using
an AND statement embedded in an IF statement. The cell entries in column K might contain the word "composite", but there will be many times when the cell will have other words as well, e.g. Composite class/Multi-managed. I've looked at other posts on the board and tried various wild card-type solutions but can't find a way to make the AND statement look at only part of the cell. =IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) ) Help would be much appreciated! Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making the AND function look at only part of a cell entry
Try using the search function. If the value is 0, it's found the text your
looking for. -- HTH, Barb Reinhardt "Cathy" wrote: I am trying to identify different conditions that might exist with data using an AND statement embedded in an IF statement. The cell entries in column K might contain the word "composite", but there will be many times when the cell will have other words as well, e.g. Composite class/Multi-managed. I've looked at other posts on the board and tried various wild card-type solutions but can't find a way to make the AND statement look at only part of the cell. =IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) ) Help would be much appreciated! Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making the AND function look at only part of a cell entry
Thanks very much. I combined search and isnumber and it works perfectly now.
"Barb Reinhardt" wrote: Try using the search function. If the value is 0, it's found the text your looking for. -- HTH, Barb Reinhardt "Cathy" wrote: I am trying to identify different conditions that might exist with data using an AND statement embedded in an IF statement. The cell entries in column K might contain the word "composite", but there will be many times when the cell will have other words as well, e.g. Composite class/Multi-managed. I've looked at other posts on the board and tried various wild card-type solutions but can't find a way to make the AND statement look at only part of the cell. =IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) ) Help would be much appreciated! Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to count the amount of cells depending on part of the cell entry | Excel Worksheet Functions | |||
| matching part of an entry in a cell | Excel Worksheet Functions | |||
| Making Cell Entry Mandatory | Excel Discussion (Misc queries) | |||
| How do I work with part of a cell entry? | Excel Worksheet Functions | |||
| extracting comments in a cell and making these part of the Chart . | Charts and Charting in Excel | |||
Linear Mode
