example data.xlsx On the attached I am using an array (not the author) to find the first time blah blah data from column A has 3 consecutive offenses. This is how my spreadsheet and data is always displayed, an offense is counted as a '1' and no offense is blank. The array I'm using currently is located in column AG for reference. What I need help with is finding the most recent or latest time that blah blah data from column A has 3 consecutive offenses following a blank cell. So on the attached , the values i need to see are as follows: AH3 should equal 4/7/2015, AH4 should equal 4/7/2015, AH5 should equal 4/14/2015, AH6 should equal 4/14/2015, and AH7 should equal 2/3/2015. So in some cases the data might be the same as what is in AG and this would be as expected, it's possible that the first time this occurred is also the most recent. Really I'm trying to find a way to ID those that had a string of offenses, a couple blanks followed by a string of offenses. your help is greatly appreciated and I hope that I've explained myself in a way that's clearer than mud
Thank you!
Mike
Bookmarks