LARGE sort

  • Thread starter Thread starter wells
  • Start date Start date
W

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
 
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
 
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.
 
Back
Top