excelrookie123
New member
- Joined
- Sep 5, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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:
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
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