Thread: Finding the LAST value in a column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Finding the LAST value in a column
Harlan Grove wrote...
....
=IF(COUNT(A65536),A65536,LOOKUP(2,1/NOT(ISBLANK(A1:A65535)),A1:A65535))

Make that

=IF(COUNTA(A65536),A65536,LOOKUP(2,1/
NOT(ISBLANK(A1:A65535)),A1:A65535))

Reply With QuoteReply With Quote