Previous Topic Next Topic

RANKING ON EXEL

Solved/Closed
LJS - Feb 7, 2010 at 04:38 AM
venkat1926 Posts 1863 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
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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