| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text
Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great. I'm able to look in one particular cell - for example: =IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","") but I'm trying to look in the range - and or the individual cells of AE33, AF33, AG33 -- through to AK33 I've tried to use OR but I've overcomplicated it or I don't understand how to use it. thought? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text
If the text is found, do you want the cell's contents or the cell's address??
-- Gary''s Student - gsnu200860 "beata" wrote: Hi. I'm trying to find the text "V70.7" within a particular range - and if I find it? Great. I'm able to look in one particular cell - for example: =IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","") but I'm trying to look in the range - and or the individual cells of AE33, AF33, AG33 -- through to AK33 I've tried to use OR but I've overcomplicated it or I don't understand how to use it. thought? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find text
just the fact that it's there - I don't care from which cell. thanks.
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text
beata wrote:
Hi. I'm trying to find the text "V70.7" within a particular range - and if I find it? Great. I'm able to look in one particular cell - for example: =IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","") but I'm trying to look in the range - and or the individual cells of AE33, AF33, AG33 -- through to AK33 I've tried to use OR but I've overcomplicated it or I don't understand how to use it. thought? Maybe this array* formula: =IF(MAX(--(ISNUMBER(SEARCH("V70.7",AE33:AK33)))),"incl V70.7") *Commit the array formula by pressing Ctrl+Shift+Enter, not just Enter or Tab. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text
=--(countif(ae33:ak33,"*"&"v70.7"&"*")0)
or =--(countif(ae33:ak33,"*v70.7*")0) Will return true (if it's there) or false (if it's not). beata wrote: Hi. I'm trying to find the text "V70.7" within a particular range - and if I find it? Great. I'm able to look in one particular cell - for example: =IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","") but I'm trying to look in the range - and or the individual cells of AE33, AF33, AG33 -- through to AK33 I've tried to use OR but I've overcomplicated it or I don't understand how to use it. thought? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find text
Thanks. While all three replies worked - I found this one the easiest.
"Dave Peterson" wrote: =--(countif(ae33:ak33,"*"&"v70.7"&"*")0) or =--(countif(ae33:ak33,"*v70.7*")0) Will return true (if it's there) or false (if it's not). beata wrote: Hi. I'm trying to find the text "V70.7" within a particular range - and if I find it? Great. I'm able to look in one particular cell - for example: =IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","") but I'm trying to look in the range - and or the individual cells of AE33, AF33, AG33 -- through to AK33 I've tried to use OR but I've overcomplicated it or I don't understand how to use it. thought? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find text in free-format text field | Excel Discussion (Misc queries) | |||
| Find repeated text in a text document in Excel | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Linear Mode
