View Single Post
 
Old 01-09-2018, 08:53 AM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default 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
Reply With Quote