Our Marketing and Development Departments are looking for information on the number of consecutive years our patrons have subscribed to two specific seasons each year from our annual offering of over 15,
We have tried creating lists for each year's seasons and then using has each list to determine the totals in each grouping of seasons, but Does Not have the preceeding season, but our numbers are way wrong.
Does anyone have a method which would yeild the information we are seeking.
Has 2013 Season A or Season B, Has 2012 Season A or Season B, Does Not Have 2011 Season A or Season B.
Thank you.
Lee Schlosser