If condition Multiple selection

[excelrookie123]

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

[WizzardOfOz]

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

[WizzardOfOz]

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