+ Reply to Thread
Results 1 to 10 of 10

boys or girls or blank

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    boys or girls or blank

    BOY FORMAL SHOE, LEATHER,VELCRO Black 34
    BOY SCHOOL SHOE, LEATHER,LACES Black 41
    BOY SCHOOL SHOE, LEATHER,LACES Black 42
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Black 28
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Black 29
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Maroon 26
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Red 26
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Red 28
    KIDS GIRLS DOLL SHOE Bronze 11
    KIDS GIRLS DOLL SHOE Bronze 1
    KIDS GIRLS DOLL SHOE Bronze 12
    KIDS GIRLS DOLL SHOE Bronze 13

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: boys or girls or blank

    Want to classify that as BOY and GIRL
    that data being on a1 , formula on b1

    To pull BOY or GIRL without the S , and leave blank if not finds both words

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: boys or girls or blank

    Expected result

    BOY
    BOY
    BOY
    GIRL
    GIRL
    GIRL
    GIRL
    GIRL
    GIRL
    GIRL
    GIRL
    GIRL

  4. #4
    Registered User
    Join Date
    03-26-2016
    Location
    São Paulo - Brazil
    MS-Off Ver
    2016
    Posts
    48

    Re: boys or girls or blank

    makinmomb

    =MID(a1;1;PROCURAR(" ";a1)-1)

    Décio

  5. #5
    Registered User
    Join Date
    03-26-2016
    Location
    São Paulo - Brazil
    MS-Off Ver
    2016
    Posts
    48

    Re: boys or girls or blank

    =MID(a1;1;SEARCH(" ";a1)-1)

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: boys or girls or blank

    Try this...

    Data Range
    A
    B
    1
    BOY FORMAL SHOE, LEATHER,VELCRO Black 34
    Boy
    2
    BOY SCHOOL SHOE, LEATHER,LACES Black 41
    Boy
    3
    BOY SCHOOL SHOE, LEATHER,LACES Black 42
    Boy
    4
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Black 28
    Girl
    5
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Black 29
    Girl
    6
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Maroon 26
    Girl
    7
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Red 26
    Girl
    8
    GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Red 28
    Girl
    9
    KIDS GIRLS DOLL SHOE Bronze 11
    Girl
    10
    KIDS GIRLS DOLL SHOE Bronze 1
    Girl
    11
    KIDS GIRLS DOLL SHOE Bronze 12
    Girl
    12
    KIDS GIRLS DOLL SHOE Bronze 13
    Girl


    This formula entered in B1 and copied down:

    =IFERROR(LOOKUP(1000,SEARCH({"Boy","Girl"},A1),{"Boy","Girl"}),"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  7. #7
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: boys or girls or blank

    Try this in B1:
    =IF(COUNTIF(A1,"*BOY*"),"BOY",IF(COUNTIF(A1,"*GIRL*"),"GIRL",""))

  8. #8
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: boys or girls or blank

    Try this formula in B1:

    =IF(COUNTIF(A1,"*boy*"),"BOY",IF(COUNTIF(A1,"*girl*"),"GIRL",""))
    If I've helped U pls click on d *Add Reputation

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: boys or girls or blank

    Thank you all , working

  10. #10
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: boys or girls or blank

    You're welcome. We appreciate the feedback!

+ 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. [SOLVED] Segregating Boys from Girls
    By wedzmer in forum Excel General
    Replies: 13
    Last Post: 07-10-2014, 09:27 AM
  2. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  3. Hello guys and girls...
    By J_whyte in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-18-2013, 03:49 AM
  4. Boys versus Girls
    By gelandl in forum The Water Cooler
    Replies: 9
    Last Post: 03-24-2009, 06:10 AM
  5. [SOLVED] Horny Teen Girls
    By Nadja in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-29-2005, 07:05 AM
  6. [SOLVED] Horny Teen Girls
    By Nadja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2005, 07:05 AM
  7. Horny Teen Girls
    By Nadja in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-29-2005, 07:05 AM

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