I have a list of students with their grades. I filter one of the grade
columns into ascending order of grades. But it just sorts that column while
all the others stay put. I want the whole lot to move together for the
obvious reason that I don't want the marks to be misallocated to the wrong
students!
eg TO FILTER into ascending order by COLUMN 2:

START WITH
Column 1 Column 2
Bob Smith C C
Sue Brown C B
Nancy Drew D A

SHOULD READ

Nancy Drew D A
Sue Brown C B
Bob Smith C C

NOT
Bob Smith C A
Sue Brown C B
Nancy Drew D C

Note I am using the FILTER function not the SORT funtion per se