Counting used cells (2000)

Topic

New Reply

I have a List and want to count the number of rows using a formula (NOT using VBA, CurrentRegion, Intersect,etc.). There are gaps in the list such that column A might finish at row 40 but column B finishes at row 32, etc.. Now I could probably use COUNTA(A:F) and MAX(), etc., but this seems very inefficient to me. Is there a neater solution out there? Cheers, Andy.

Reply | Quote

Replies

Try using Excels =Rows(range) function

zeddy

Reply | Quote

If the column of interest is of numeric type, that is, it houses numbers or dates, use:

=MATCH(9.99999999999999E+307,A:A)

If the column of interest is of alphanumeric type, that is, it houses text-formatted values, use:

=MATCH(REPT(“z”,50),A:A)

Aladin

Reply | Quote