| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Perform search for a one letter match.
Hello all,
I'm looking to find one letter "Q" in column F (value is F has mix # and letter that can range from 5 to 10 characters), and then return the as y or true in another cell from the same row. Is there a formula to perform this task? Thank you in advance for your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Perform search for a one letter match.
Assuming your data starts in Row 2, put this in Row 2 of whatever column you
want your "Y" to be shown in and copy it down... =IF(COUNTIF(F2,"*Q*"),"Y","") -- Rick (MVP - Excel) "binh" wrote in message ... Hello all, I'm looking to find one letter "Q" in column F (value is F has mix # and letter that can range from 5 to 10 characters), and then return the as y or true in another cell from the same row. Is there a formula to perform this task? Thank you in advance for your help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Perform search for a one letter match.
Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N") Non-case-sensitive =IF(ISNUMBER(SEARCH("q",F2)),"Y","N") Copy down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "binh" wrote: Hello all, I'm looking to find one letter "Q" in column F (value is F has mix # and letter that can range from 5 to 10 characters), and then return the as y or true in another cell from the same row. Is there a formula to perform this task? Thank you in advance for your help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Perform search for a one letter match.
Case-sensitive
=IF(ISNUMBER(SEARCH("Q",F2)),"Y","N") Case-sensitive? Hmmm "Luke M" wrote: Case-sensitive =IF(ISNUMBER(SEARCH("Q",F2)),"Y","N") Non-case-sensitive =IF(ISNUMBER(SEARCH("q",F2)),"Y","N") Copy down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "binh" wrote: Hello all, I'm looking to find one letter "Q" in column F (value is F has mix # and letter that can range from 5 to 10 characters), and then return the as y or true in another cell from the same row. Is there a formula to perform this task? Thank you in advance for your help! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Perform search for a one letter match.
Argh, you got me! Forgot to change the function to:
=IF(ISNUMBER(FIND("Q",F2)),"Y","N") Thanks for pointing that out! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Teethless mama" wrote: Case-sensitive =IF(ISNUMBER(SEARCH("Q",F2)),"Y","N") Case-sensitive? Hmmm "Luke M" wrote: Case-sensitive =IF(ISNUMBER(SEARCH("Q",F2)),"Y","N") Non-case-sensitive =IF(ISNUMBER(SEARCH("q",F2)),"Y","N") Copy down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "binh" wrote: Hello all, I'm looking to find one letter "Q" in column F (value is F has mix # and letter that can range from 5 to 10 characters), and then return the as y or true in another cell from the same row. Is there a formula to perform this task? Thank you in advance for your help! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Perform search for a one letter match.
Thank you again for your help, and it works!
Regards, Binh -- Thank you in advance for your help! "Luke M" wrote: Case-sensitive =IF(ISNUMBER(SEARCH("Q",F2)),"Y","N") Non-case-sensitive =IF(ISNUMBER(SEARCH("q",F2)),"Y","N") Copy down as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "binh" wrote: Hello all, I'm looking to find one letter "Q" in column F (value is F has mix # and letter that can range from 5 to 10 characters), and then return the as y or true in another cell from the same row. Is there a formula to perform this task? Thank you in advance for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup 2 columns of data, perform, match, output results | Excel Worksheet Functions | |||
| search for words with capital letter at end | Excel Discussion (Misc queries) | |||
| why is there no excel11.xlb file when I perform a search? | Excel Discussion (Misc queries) | |||
| How to perform Search and Replace on "Tilde", CHAR(126), ~ | Excel Worksheet Functions | |||
| search in the entire sheet for different letter and cal. | Excel Worksheet Functions | |||
Hybrid Mode
