+ Reply to Thread
Results 1 to 8 of 8

Small search problem

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Small search problem

    So I want to write a small fromular that checks whether a certain character is present in a cell.

    My column looks like that

    A
    62 nb
    60 b
    58 nb
    40 b

    I now want to write a fromular into the column B that checks whether there is the letter "b" in column A. However I cant just search for b since its either as b or nb and there is also a number present.
    Thanks for your help

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,349

    Re: Small search problem

    Try this:

    =IF(ISERROR(FIND("n",A1)),"No","Yes")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Re: Small search problem

    Thanks for your help. Works like a charm. However, I forgot to mention something. I have multiple criteria.

    The table rather looks like this

    A

    62 nb
    64 b
    57 g
    68 ng

    I now want to write a formula in colomn B that prints me either b or g so the result should look like this:
    A__________B

    62 nb______b
    64 b_______b
    57 g ______g
    68 ng______g

    Thanks for your help.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,349

    Re: Small search problem

    OK, so that's two criteria, and neither of them is "n". Before we go any further, what's the REAL deal here?

  5. #5
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Re: Small search problem

    That is the real deal I just forgott the important part in the question the first time I asked cause I only realized it once I entered the formula into my data sheet. In total I have 4 letters g b y and m. However, they are intertwined with other letters and numbers. However, the specific letter only occurs once per row and I need to filter for the specific letter. As soon as I know how to do it with two letters I can also do it with 4.

    Thank you for your help.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,349

    Re: Small search problem

    This might help:

    =IF(COUNT(FIND({"g","b","y","m"},A1))>0,"Ja","Nein")

  7. #7
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Re: Small search problem

    Thanks for your help. Since I didnt want a binominal answer (Yes;No) I changed the first formula and it now works very well.
    =IF(ISERROR(FIND("b";A28));IF(ISERROR(FIND("g";A28));IF(ISERROR(FIND("r";A28));IF(ISERROR(FIND("y";A28));"No";"y");"r");"g");"b")

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,349

    Re: Small search problem

    Glad to have helped a bit.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 07-11-2018, 12:13 PM
  2. [SOLVED] Index small search about 2 word
    By R0CKY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2017, 04:54 AM
  3. [SOLVED] Struggling to get a small search function working correctly
    By bodhi808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2013, 08:34 PM
  4. [SOLVED] Wildcard search within IF and LARGE / SMALL INDEX searches.
    By Mainiac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2013, 11:14 AM
  5. Replies: 6
    Last Post: 04-29-2011, 08:00 PM
  6. Small problem...
    By Green_Monkey23 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2006, 12:36 AM
  7. [SOLVED] small problem
    By PH NEWS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-22-2006, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1