I have a list of people with ID's, Start Date, End Date, Month (which is the month their screening was given), Score (of screening). What I need to know every month is which people were active based on their start and end date, but did not have a screening. My table has multiple rows for each person because it has the score each month.
I think it would be a Calculate with Allexcept, but I can't seem to get it to work. Thank you so much for your help!!
