Hi,

Let's say I have a column with only a's.

a
a
a

a


a

For example last "a" is on the 10th line of excel (but the last row could be 20th or whatever). How do I count the blankspaces till the last non blank cell. In this case the result would be 4 blank cells.

Thank you very much