1

I have a master sheet where data is entered. I would like the other sheets in the book (which currently auto-populate from the master sheet) to sort (in descending order) by their respective column in the master sheet. For example: Sheet "Alice" sorts by column "Alice" from the master sheet, sheet "Bernie" sorts by column "Bernie from the master sheet, etc.

So if my "Master" sheet is

 Class      Alice      Bernie      Courtney
 Math         1          2            
 English      3          1            2
 Science      2          3            1

Then sheet "Alice" would auto-sort to:

 Class      Alice      Bernie      Courtney
 English      3          1            2
 Science      2          3            1
 Math         1          2

And sheet "Bernice" would auto-sort to:

 Class      Alice      Bernie      Courtney
 Science      2          3            1
 Math         1          2            
 English      3          1            2

And sheet "Courtney" would auto-sort to

 Class      Alice      Bernie      Courtney
 English      3          1            2
 Science      2          3            1
 Math         1          2

(Please note each sheet has the same values for each entry in the matrix--the order of the rows is simply being rearranged according to which column the sheet is meant to sort by.)

Improve this question
0

1 Answer 1

Reset to default
1

Try

Alice! A1: 

 =SORT('Master'!A1:D4,2,0)

Bernice! A1:

 =SORT('Master'!A1:D4,3,0)

and so on..

Improve this answer
1
  • 1
    This answer avoids writing a custom script. Only use scripts as a last resort n.n
    – hlecuanda
    Oct 1, 2017 at 0:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.