Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place an X next to a cell that contains a word
I have a column that has words in each cell. I want to search through the column and for any cell containing the word 'base' i want to place an X in the cell next to it. How can I do this? Please help! Thanks, Jerred -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=550489 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place an X next to a cell that contains a word
Further Info: The cells containing words just dont contain one word -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=550489 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place an X next to a cell that contains a word
=IF(ISERROR(SEARCH("base",D15,1)),"","x").
replace the d15 with the first reference to search and copy down in my lttle test,base,scott base,baseball returned an x ,a blank cell or a cell with no base remained Blank -- paul remove nospam for email addy! "jerredjohnson" wrote: Further Info: The cells containing words just dont contain one word -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=550489 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place an X next to a cell that contains a word
Let's say your column of data is Column A. In Column B enter the formula:
=IF(ISERROR(SEARCH("base",A1)),"","X") Copy the formula down Column B as needed. HTH, Elkar "jerredjohnson" wrote: I have a column that has words in each cell. I want to search through the column and for any cell containing the word 'base' i want to place an X in the cell next to it. How can I do this? Please help! Thanks, Jerred -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=550489 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place an X next to a cell that contains a word
My hat off to you, thanks! -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=550489 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place an X next to a cell that contains a word
One mo
=if(countif(a1,"*" & "Base" & "*")=0,"","X") or =if(countif(a1,"*Base*")=0,"","X") or =if(countif(a1,"*" & C999 & "*")=0,"","X") if c999 holds the word Base. jerredjohnson wrote: I have a column that has words in each cell. I want to search through the column and for any cell containing the word 'base' i want to place an X in the cell next to it. How can I do this? Please help! Thanks, Jerred -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=550489 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) |