Results 1 to 3 of 3

Thread: If condition Multiple selection

  1. #1

    If condition Multiple selection



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Excelguru's,


    Can't help asking this, perhaps, silly question:
    I need a selection of the group(or individual), if the group meets a certain condition.
    Here you see some of my data:


    Date
    Announced
    Date
    Effective
    Date
    Effective/
    Unconditional
    Date
    Withdrawn
    Status Target Name Target
    CUSIP
    Target
    Primary
    SIC
    Code
    09/04/1998
    09/04/1998
    09/04/1998
    -
    Completed Acorn Group PLC 00497M
    7379
    03/20/2000
    03/20/2000
    03/20/2000
    -
    Completed Acquisitor PLC 00499Q
    7812
    03/17/2000
    03/17/2000
    03/17/2000
    -
    Completed Acquisitor PLC 00499Q
    7812
    08/17/2000
    -
    -
    -
    Pending Action Computer Supplies Hldgs 00506L
    7372
    05/10/1999
    -
    -
    10/18/1999
    Withdrawn Action Computer Supplies Hldgs 00506L
    7372
    09/03/2001
    10/17/2001
    10/09/2001
    -
    Completed Action PLC 00524C
    7372
    10/16/2001
    -
    -
    -
    S Buyer ActionLeisure PLC 00499L
    3751

    So:


    IF there is a field covered in the column "date withdrawn" I need all the rows of the corresponding firm to be marked/selected/given value "x", whatsoever. Or the other way around, including all firms IF they have a value for "date withdrawn"

    E.g. for above:
    Action Computer Supplies

    Would be suburb if you can tell me how… I cannot figure it out with the IF/OR/AND functionalities.
    Also tried to write in VBA, is it more appropriate for that section on this forum?

    Thank you in advance!



    Joost

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Use sumif formula in your x column. =if(sumit(date,target=f2)>0,"x"," ")

  3. #3
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    I copied your data starting in column A. A6 is the first valid data

    In I6 copy the formula
    =IF((SUMIF($F$6:$F$12,"="&F6,$D$6:$D$12)),"x","")

    Then copy it down

    To make it work, column D must be a valid date not text

Posting Permissions

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