LARGE sort

[wells]

How can I do this: I have a list of names along with
scores. I want the top 25 scores to be moved onto
another worksheet, which I know I can do with the LARGE
function. However, I also want the names associated with
those scores to be moved to the new worksheet. Ideas?

Thanks, SAW

 

[Dave R.]

Why not just do your sort of scores, then copy and paste the names/scores
elsewhere?

This will work if everyone has a different score, but I'd copy and paste the
names/scores...

Names in A1:A250, scores in B1:B250.

Select 25 cells (say C1:C25), and enter in the formula bar,

=INDEX(A1:A250,MATCH(LARGE(B1:B250,ROW(INDIRECT("1:25"))),B1:B250,0))

entered with CTRL-SHIFT-ENTER

 

[Earl Kiosterud]

SAW,

If you want to do this manually, sort the table on the score column
descending. Cut/Paste the rows. To physically move them automatically will
require a macro, I think.

 

[Aladin Akyurek]

See:

http://tinyurl.com/22x6k