View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Big Kahuna Big Kahuna is offline
external usenet poster
 
Posts: 1
Default How many rows after sorting?

I have a worksheet with 4465 rows of data. The data is sortable using the
list function. Any combination of sorting criteria brings back a different
set of results.

I want to be able to know the number of rows ( each row is a person) so that
I can see how many people out of the total number fall into a particular
category.

Even better would be a percentage, but by getting the number of people I
could manually convert to percentage.

Much appreciated for any adivce in advance.