# Thread: If condition Multiple selection

1. ## If condition Multiple selection

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?

Joost

2. Use sumif formula in your x column. =if(sumit(date,target=f2)>0,"x"," ")

3. 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
•