![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Good morning all
I have a excel spreadsheet with over 9k lines in it. Rather than going through each line individually, I was hoping someone could tell me how I could populate a field based on the attached example. The example shows four columns and what i would like to do is determine when a member has multiple professional "TYPES" that occurred within a year of each other. The formula would populate the "RETRACT" field with "Y" if a member has more than 1 professional type within a year. If the member has a "Institutional" AND Professional type, the retract field would remain empty. Any help would be appreciated. Thanks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create a formula to count all occurances of HH but multiply by 0.5 first | stupidgirl | Excel | 6 | 06-14-2016 03:50 PM |
| Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
Units worked per time period
|
carmang | Excel | 4 | 07-24-2014 08:24 AM |
How do I calculate planned work for a given time period
|
bumpui | Project | 1 | 06-04-2014 06:37 AM |
| Allocation of task in certain period of time | mati2 | Project | 1 | 02-25-2012 07:59 AM |