View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Ranking or sorting function

I don't understand why this is a problem. Maybe you're leaving out a bit of
info?

If you're using a RANK formula, every score will receive a rank number and
then you can sort by that rank number.

Biff

"craig" wrote in message
...
I am looking for a way to have some information ranked in ascending order.
I
have a list of names with test scores. I need to rank each name based on
their test score. I am having trouble when there are test scores the same.
This is throwing off the ranking as the scores are the same number. Does
anyone have a function I can use for ranking when the numbers are the
same.
All persons must show on my results and their test results.

Thanks,
Craig