View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Ranking or sorting function

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