Rank x of x

[PHnew]

I am preparing "report cards" for 20 employees. The report card will reflect only the employee's rankings on certain production criteria.

I have information on 20 differrent people. On one criteria I want to rank, each of the 20 people have comparative data. On some other criteria, not all have data. I've figured out how to rank each comparative data set, but I'm wondering if there is a way to reflect a result of something like "1 of 20" or "1 of 7" so that one the data sets where not everyone is being compared it shows the number of people being ranked.

I know that zeros aren't counted, but in this case, some times they aren't even being counted in the group for comparison.

 

[CWatts]

Zeroes ARE counted if they're entered. if they're blank cells then no worries.

You can use the COUNTA formula to see out of how many people there are. For example:

=RANK(B2,$B$1:$B$10)&" of "&COUNTA($B$1:$B$10)