Excel community,
I need help with this problem I have been trying to figure out for a few days. I have a spreadsheet with the following:
Column A: Y or N or NotRcvd or Blank. This determines whether that job was completed on time or not.
Column B: Persons Name. This shows who completed the job. There are about 12 different names in this column.
Column C: Date of Job. I have dates going back more than a year.
I would like to know the longest streak by a specific person in a specific date range. For example if one the people in column B is "John". I would like to know what the longest streak of "y"'s in a row in column A that "John" had between the date range of the previous 12 months.
Any help would be much appreciated.
Thanks!
I need help with this problem I have been trying to figure out for a few days. I have a spreadsheet with the following:
Column A: Y or N or NotRcvd or Blank. This determines whether that job was completed on time or not.
Column B: Persons Name. This shows who completed the job. There are about 12 different names in this column.
Column C: Date of Job. I have dates going back more than a year.
I would like to know the longest streak by a specific person in a specific date range. For example if one the people in column B is "John". I would like to know what the longest streak of "y"'s in a row in column A that "John" had between the date range of the previous 12 months.
Any help would be much appreciated.
Thanks!