Thank you for your replies! The issue is, I am using one sheet for entering
the data and another sheet to summarize all of the people with their test
scores. This is because the data sheet has way to much information.

On the results sheet I want to be able to have the scores sorted ascending
automatically and then be able to look up who each of the scores belong to.
I attempted to rank each score on the datasheet and then do a vlookup off of
each rank to bring over to the results sheet the score and the name of the
person but that doesn't work when their are similar test scores which have
the same rank.

Below is an example I get the information from the data sheet and it is
summarize in the summary sheet. (The rank numbering 1,2,3 etc is typed in on
the summary sheet and the data sheet is the rank formula. I then use the
rank number on the summary sheet to do a vlookup for the remainer info on the
data sheet.

Summary Sheet

Rank Name Test Score
1 Jennifer 75
2 Matt 80
3 N/a N/A
4 Scott 90


Data sheet

Rank

2 Mike 80
4 Scott 90
1 Jennifer 75
2 Matt 80


Thanks
Craig


"Mike H" wrote:

Craig,

With the test scores in Column B1 down type this in C1 and drag down as
required.

=RANK(B1,B$1:B$50)

If 2 scores have an equal rank then they will both get the same rank For
example if there is a joint No1 they will both get 1 and there will be no No2.

Mike



"craig" wrote:

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