Excel can be used to put data into a sequence. This is usually refered to as sorting. Data can be sorted in an Ascending order (A to Z, 1 to 10) or Descending order (Z to A, 10 to 1).
We can also choose whether to sort all our columns or just one. We can even sort by more than one column at the same time!
Watch the attached Sorting Spreadsheet Data Video Tutorial to help. (2 minutes)
Open your T3_FF Spreadsheet and re-save it as surname_firstname_T4_Sorts
Duplicate your worksheet by:
1) right clicking on the TAB at the bottom and choose Copy or Move from the menu
2) then make a Copy of your worksheet and rename the new TAB Sorted
You should now have 2 worksheets the same!
3) Sort all of your Sorted worksheet by the Total column ( Largest to Smallest!)
4) and then SortONLY the Chart Position column (Smallest to Largest!)
