Hi Guys,
Couldnt find anything on the board or via Google. Using 2010:
Hope I explain this well enough. A single column either has a blank or some number (consider it just a random number).
I want to count the blank cells between the last and second last value in the second column. And in a different results cell, count the blanks from the second to last value to the third to last value. These 2 results cells will continue to use the last, second, and third to last values as I continue to enter more blanks or numbers as I update the worksheet.
IE
blank
blank
blank
3
blank
blank
4
blank
10
blank
blank
blank
blank
blank
blank
20
Thanks!
Bookmarks