Thread: Finding the most recent month's (or whatever) data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Finding the most recent month's (or whatever) data
find row number of last not emty cell in column A

=ROW(INDEX(A:A,LARGE(IF(A1:A65000<"",ROW(A1:A6500 0)),1),))

paste in and then CTRL+SHIFT+ENTER

Reply With QuoteReply With Quote