Use sumif formula in your x column. =if(sumit(date,target=f2)>0,"x"," ")
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
AnnouncedDate
EffectiveDate
Effective/
UnconditionalDate
WithdrawnStatus Target Name Target
CUSIPTarget
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/1999Withdrawn 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
Use sumif formula in your x column. =if(sumit(date,target=f2)>0,"x"," ")
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
Bookmarks