View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hoffma Hoffma is offline
external usenet poster
 
Posts: 1
Default Count Number of Rows

I filtered non-numerical data in a spreadsheet and need to count the number
of remaining rows. The row numbers are not in order due to filtering. What
is an easy way to count the number of rows remaining? COUNTA doesn't work.