Help with automatically sorting data


J

Jim48762

I have a list of golfers names in A1-A6 (A1=Smith, A2=Jones,A3=Johnson,
A4=Walker, A5=Martin and A6=Peach.

In column B next to their names are each golfer's score (B1=75, B2=78,
B3=80, B4=84, B5=85, B6=88).

In column C (C1-C6) I want the golfers names to appear in order (C1-C6)
based on their scores in column B. So if I changed the score in B4 to "72",
I want his name to move from C4 to C1 and the names that were in C1, C2 and
C3 to move down 1 spot each in the C Column.

I also need this to work if two or more of the golfers have the same score.
For example...if three golfers all tie for the best score with a 70, I need
them to appear in C1-C3 and the rest of the golfers to appear in order in
C4-C6 respectively.

Is this possible?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top