|Using your example of F7, F8, etc., as long as there are no blank cells in Sheet1!F1:F8 nothing in Column F below F8, this formula should work:|
The INDIRECT function converts a text string into a cell reference.
The COUNTA function returns the number of cells within a range that contain data.
Therefore, with data in every cell of the range F1:F8, the formula above will evaluate to:
When you add data to F9, the COUNTA function will return 9, etc.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.