I have data in column E with no blank entries from E4 to currently E224.
When the job in hand has been done I enter a date in column D.
I would like a formula in D 250 which would find the last row in column E with data in it currently E224 and then count the number of rows in column D that are blank.
I hope this makes sense and as ever your help is appreciated.
EDIT: I should add that the position of the formula will move down as records are added
When the job in hand has been done I enter a date in column D.
I would like a formula in D 250 which would find the last row in column E with data in it currently E224 and then count the number of rows in column D that are blank.
I hope this makes sense and as ever your help is appreciated.
EDIT: I should add that the position of the formula will move down as records are added