Want to sort the one column and the whole columns will be effected
Posted by pessona on June 22, 2000 2:02 AM
Hope somebody can help me. I want to sort a column and then the rest of the columns will be sorted accordingly.
FOr example, I have a table in a worksheet containing studentID, Marks for every Subject, Overall Marks and Percentage. The table looks like this..
StudentID Subejct1 Subject2 Subject3 Overall Percentage
1254 10 10 10 30 100%
1145 9 8 5 22 73%
5441 9 9 10 28 93%
and so on..
I want to sort the percentage so that student with highest percentage will be at the top and student with the lowest mark will be at the bottom(descending). This must also automatically sort the other columns. I've tried using the sort function in the Data menu, but it doesn't work. Does anybody has any idea how to do it?