RANKING ON EXEL

Solved/Closed
LJS - Feb 7, 2010 at 04:38 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Feb 7, 2010 at 07:34 PM
Hello, In exel i know its possible to rank data, but im stuck on how to do this:

Say i have the following data:

Activities: 16-19 20-24 25-29 30-44 Rank Activitites
Walking 27 31 32 36
Snooker/pool/billiards 32 43 28 25



I want in the column labelled 'Rank activities' to show the rank of the activity in terms of the number of each age group, for example walking adds up to 126 and 'Snooker Pool Billiards' adds to 128 so therefore 'Snooker pool billiards' is ranked 1 and Walking ranked 2.

What formula would i use?
PLEASE HELP ITS FOR COURSEWORK

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Feb 7, 2010 at 07:34 PM
one way is like this
suppose the data is like this from A1 to E2

snooker 32 42 28 35
walking 27 31 32 36

now in F1 add the numbers of the row, similarlyF2.
highlight the whole data and click data(menu)-sort according to column F descending (in the sort window click the radio button "no header row" in the bottom and then click ok)
0