Results 1 to 7 of 7

Thread: Search and mark
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Search and mark

    Hey all,

    I have a excel sheet that I need to search row by row for specific keyword ( GDV5 ) and if it is found anywhere in the row it will write to Column B yes , if it is not found in the whole row it will write NO.

    I hope that explains my point. I know how to look for a specific clumn for a data and then write a yes/no , but to search the whole row regardless of how many columns for that row. Again if found anywhere in the whole row , Yes/No in column B.

    HELP{ !!! }

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Search and mark

    Try

     ABCDEF
    1      
    2 Yes GDV5  
    3 No    
    4 Yes   GDV5
    5 No    
    6 No    
    7 No    
    8 YesGDV5   

    CellFormula
    B2=IFERROR(IF(MATCH("GDV5",2:2,0),"Yes"),"No")



    Note: Change the number of times Excel iterates a formula
    - Click the File tab, click Options, and then click the Formulas category. ...
    - In the Calculation options section, select the Enable iterative calculation check box.
    - Type the number 1 of iterations in the Maximum Iterations box.
    Regards Dante Amor

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Search and mark

    Or how about:

    =IF(ISNA(MATCH("GDV5",2:2,0)),"No","Yes")

    Note: Change the number of times Excel iterates a formula
    - Click the File tab, click Options, and then click the Formulas category. ...
    - In the Calculation options section, select the Enable iterative calculation check box.
    - Type the number 1 of iterations in the Maximum Iterations box.
    Regards Dante Amor

  4. #4
    New Member
    Join Date
    Jun 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Search and mark

    I am referring to a column in the row that has ( .localized/testuser-GDv5.1.vmwarevm ) , so GDV5 is the key word I want mentioned. So if it exists anywhere in the whole row write yes to clumn B

  5. #5
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Search and mark

    Try this

    =IF(ISNA(MATCH("*GDV5*",2:2,0)),"No","Yes")
    Last edited by DanteAmor; Sep 25th, 2019 at 07:49 PM.
    Regards Dante Amor

  6. #6
    New Member
    Join Date
    Jun 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Search and mark

    Machine Name Contains Windows 7 VM Full name Email Address OS Serial Number Last Check-in VMWare - Virtual Machine info VMWare - Virtual Machine info VMWare - Virtual Machine info
    MacBook Pro User1 User1@company.com Mac OS X 10.13.6 Serial1 2 minutes ago VMWare VM #1 File Name: /Users/User1/Virtual Machines.localized/User1-GDv5.1.vmwarevm/User1-GDv5.1.vmx displayName = User1-GDv5.1 Network Type: nat
    MacBook Pro User2 User2@company.com Mac OS X 10.13.6 Serial2 07/25/2019 at 12:26 PM VMWare VM #1 File Name: /Users/User2/Virtual Machines.localized/User2.vmwarevm/User2.vmx displayName = User2 Network Type:
    MacBook Pro User3 User3@company.com Mac OS X 10.14.4 Serial3 Today at 6:08 AM VMWare VM #1 File Name: /Users/User3/Virtual Machines.localized/Fresh_Install_macOS 10.14.vmwarevm/Fresh_Install_macOS 10.14.vmx displayName = Fresh_Install_macOS 10.14 Network Type: nat VMWare VM #2 File Name: /Users/User3/Virtual Machines.localized/macOS 10.14 2.vmwarevm/macOS 10.14 2.vmx displayName = macOS 10.14 Network Type: nat VMWare VM #3 File Name: /Users/User3/Virtual Machines.localized/User3 GDV5.1.vmwarevm/User3 GDV5.1.vmx displayName = User3 GDV5.1 Network Type: nat


    Basically i want Column B to hold either yes or no if the row contains GDv5 anywhere within it.

    Thanks
    Last edited by geezup; Sep 26th, 2019 at 11:20 AM.

  7. #7
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Search and mark

    Did you try the formula in post #5 ?

    A B C D E F G H I J
    1 Machine Name Contains Windows 7 VM Full name Email Address OS Serial Number Last Check-in VMWare - Virtual Machine info VMWare - Virtual Machine info VMWare - Virtual Machine info
    2 MacBook Pro Yes User1 User1@company.com Mac OS X 10.13.6 Serial1 2 minutes ago VMWare VM #1 File Name: /Users/User1/Virtual Machines.localized/User1-GDv5.1.vmwarevm/User1-GDv5.1.vmx displayName = User1-GDv5.1 Network Type: nat
    3 MacBook Pro No User2 User2@company.com Mac OS X 10.13.6 Serial2 07/25/2019 at 12:26 PM VMWare VM #1 File Name: /Users/User2/Virtual Machines.localized/User2.vmwarevm/User2.vmx displayName = User2 Network Type:
    4 MacBook Pro Yes User3 User3@company.com Mac OS X 10.14.4 Serial3 Today at 6:08 AM VMWare VM #1 File Name: /Users/User3/Virtual Machines.localized/Fresh_Install_macOS 10.14.vmwarevm/Fresh_Install_macOS 10.14.vmx displayName = Fresh_Install_macOS 10.14 Network Type: nat VMWare VM #2 File Name: /Users/User3/Virtual Machines.localized/macOS 10.14 2.vmwarevm/macOS 10.14 2.vmx displayName = macOS 10.14 Network Type: nat VMWare VM #3 File Name: /Users/User3/Virtual Machines.localized/User3 GDV5.1.vmwarevm/User3 GDV5.1.vmx displayName = User3 GDV5.1 Network Type: nat

    Formeln der Tabelle
    Zelle Formel
    B2 =IF(ISNA(MATCH("*GDV5*",2:2,0)),"No","Yes")
    B3 =IF(ISNA(MATCH("*GDV5*",3:3,0)),"No","Yes")
    B4 =IF(ISNA(MATCH("*GDV5*",4:4,0)),"No","Yes")
    Last edited by DanteAmor; Sep 26th, 2019 at 12:10 PM.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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