Quote:
Originally posted by iHype.
Slobro is there a way to sort the songs averages from highest to lowest and users in alphabetical order in Excel?
|
To sort songs, assuming you have song title/artist as rows, and users as columns:
- Select everything (click that top left grey square (above the '1' and in front of the 'A')
- Go to the 'Data' tab
- Click 'Sort'
- Check 'My data has headers'
- Click the 'Sort by' drop down menu and select the column with average scores