View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LRR via OfficeKB.com
 
Posts: n/a
Default ranking with some blank spaces

I am creating a ranking sheet with 20 rows. There will be a differing amount
of numbers to rank. Sometimes there may only be 10 numbers to rank and
sometimes more or less. How do you prevent the blank spaces from being part
of your ranking? In other words, if I have 10 numbers, I want to rank 1
through 10 and ignore the spaces 11 through 20.

--
Message posted via http://www.officekb.com