Quote:
Originally Posted by ads25  Hi all,
Just a quick question in regards to sorting a table on Excel. Is it possible to sort a table like you can on some websites by clicking on the header of each column. For example i just made up this table: | Team | P | W | L | D | Pts | | Chelsea | 20 | 19 | 0 | 1 | 58 | | Liverpool | 20 | 15 | 2 | 3 | 48 | | Man Utd | 20 | 12 | 1 | 7 | 43 | | Arsenal | 20 | 10 | 5 | 5 | 35 |
So if i click on say 'W' then i can sort the table by the wins, or if i click on 'L' i can sort it by losses etc.
Cheers  |
As you know mate, I don't know much about Excel. But I am under the impression that by clicking on either A-Z Ascending or A-Z Descending, that it would rearrange that column from either highest to lowest or lowest to highest.