For reference, I’ve attached a sample spreadsheet.
I’m trying to find a way to calculate the max number of blank cells between a range of cells. As an example, in row two of my data, the result would be 3 using the range of F2:N2. Can this be done without the use of VB? Anyone have any suggestions on how to accomplish this?
Thanks in advance!