Formula that determines multiple occurances within a pre-determined time period
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
|