for the last row location,

=ROW(INDIRECT(ADDRESS(MAX(IF($A$1:$A$500<"",ROW($ A$1:$A$500))),MAX(IF($A$1:$A$500<"",COLUMN($A$1:$ A$500))))))

still validate with Ctrl + Shift + Enter


--
isabelle


Le 2011-11-04 03:13, isabelle a écrit :
hi JumboShrimps,

for the last cell location
that is an array formula to validate with ctrl+maj+enter

=ADDRESS(MAX(IF(A1:A500<"",ROW(A1:A500))),MAX(IF( A1:A500<"",COLUMN(A1:A500))))