Thread: Last Row used in calculation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Last Row used in calculation
try:

=INDIRECT("A"&MAX(IF(LEN($A$1:$A$15)0,ROW($A$1:$A $15),)))
Reply With QuoteReply With Quote