Identifying bottom of list

[T De Villiers]

Hi, Thanks to an earlier thread I have the folowing:

=countif(a1:a100,"")

but I need to vary the formula with the no of rows per data.

so if Row 123 is last row

I have = countif(a1:a123,"")

Maybe I can incorporate

LastRow = Cells(Rows.Count,1).End(xlUp).Row into this

 

[Guest]

T De Villiers -

Use this formula to get the last row being used:
=MAX(IF(A1:A10000<>"",ROW(A1:A10000),""))

Also, this is an array formula so enter it using ctrl+shift+enter.

Hope that helps.