I didn't know the Row function could be used to count rows

I understand what you mean but *technically* I used the ROWS function.
There's a difference between the ROW function and the ROWS function.

The ROW function returns an *array* of numbers based on the row references:

ROW(A10:A15)

Returns the vertical array: 10;11;12;13;14;15

ROWS returns a single value that is the count based on the row references:

ROWS(A10:A15) = 6

The same thing applies to the COLUMN and the COLUMNS functions.

COLUMN(A1:E1)

Returns the horizontal array: 1,2,3,4,5

COLUMNS(A1:E1) = 5

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Hi, Jumping in,
I didn't know the Row function could be used to count rows. I thought it
just returned a row number. I like how you use that to get an incrementing
number, regardless of where you are on the sheet. Thanks. Always learning.
Regards - Dave.