Thread: finding the maximum number of used cells in any column of a table
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
  
Posts: 527
Default finding the maximum number of used cells in any column of a table
or this may work

=COUNTA(Sheet1!A:D)/4

In anycase you need to reference the sheet to which the name refers so Ron's
second formula

=MAX(INDEX(SUBTOTAL(3,OFFSET(Sheet1!$A:$A,,ROW(IND EX(Sheet1!A:A,1):INDEX(Sheet1!A:A,41))-1)),0))

Reply With QuoteReply With Quote