Counting years of range and returning value if matches criteria
I am trying to return value 0 and 1:
Value=1 when all the year 1995-2003 has value in column D >= 3.
Value = 0 if column D >=3 at any year between 1999-2003 but this should exclude firms that are in group 1(which has valued coded 1 when column D >=3)