I am attempting to calculate consecutive years in the attached file - for each year of activity the value is "1" if no activity the value is 0.
From Right to left (2015 to 1987) if there is a value of 1 then continue to move to the next column to the left. If the value is 0 then return the column header year and discontinue any calculations.
Attached is the file layout - let me know if there are any questions on what I am asking. I usually do this in crystal reports but am hoping to get away from the labour-intensive setup.
Thanks very much - CS