Related:
- Help for sorting top 5 values on Excel
- Gta 5 download apk pc - Download - Action and adventure
- Forza horizon 5 download free - Download - Racing
- Bluestacks 5 - Download - Android emulators
- High street 5 - Download - MMO
- Unreal engine 5 download - Download - Game development
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 17, 2011 at 06:21 AM
Oct 17, 2011 at 06:21 AM
suppose sample data in columns A,B,C are like this
name data1 data2
a 1 8
s 2 7
d 3 6
f 3 5
g 4 4
h 5 3
j 6 2
k 7 1
l 8 2
in D1 enter sortB
in D2 copy this formula
=LARGE($B$2:$B$10,ROW(A1))
copy D2 down
in E1 enter sortC
in E2 copy this formula
=LARGE($C$2:$C$10,ROW(B1))
copy E2 down
in F1 entier final sort
in F2 copy this formula
=IF(D2=E2,D2,E2)
copy F2 down
name data1 data2
a 1 8
s 2 7
d 3 6
f 3 5
g 4 4
h 5 3
j 6 2
k 7 1
l 8 2
in D1 enter sortB
in D2 copy this formula
=LARGE($B$2:$B$10,ROW(A1))
copy D2 down
in E1 enter sortC
in E2 copy this formula
=LARGE($C$2:$C$10,ROW(B1))
copy E2 down
in F1 entier final sort
in F2 copy this formula
=IF(D2=E2,D2,E2)
copy F2 down
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 17, 2011 at 10:20 PM
Oct 17, 2011 at 10:20 PM
why do you need the formula why don't you sort according to first by column B and then by column c descending.
by this sorting you get like this
hdng1 hdng2 jhdng3
George 28 65
Antonis 18 55
German 16 58
Jono 15 47
Graeme 15 46
Jules 10 36
Matt 9 47
Wazza 7 40
is this not what you want
what you do:
1.as you are disturbing the data copy the data in another sheet
2. go back to original sheet and select the whole data (if there is no gap it is enough to select any one cell in the data)
3..click data(menu)-sort
4. in sort window topmost "sort by" choose the column heading of column B
5.in the right side radio buttons choose "descending"
6.under "then by"
7.choose the column heading of column C and choose again descending
8.at the bottom under "my date range has" choose "header row"
9. click ok
if in doubt see help under "sort"
by this sorting you get like this
hdng1 hdng2 jhdng3
George 28 65
Antonis 18 55
German 16 58
Jono 15 47
Graeme 15 46
Jules 10 36
Matt 9 47
Wazza 7 40
is this not what you want
what you do:
1.as you are disturbing the data copy the data in another sheet
2. go back to original sheet and select the whole data (if there is no gap it is enough to select any one cell in the data)
3..click data(menu)-sort
4. in sort window topmost "sort by" choose the column heading of column B
5.in the right side radio buttons choose "descending"
6.under "then by"
7.choose the column heading of column C and choose again descending
8.at the bottom under "my date range has" choose "header row"
9. click ok
if in doubt see help under "sort"
Oct 17, 2011 at 09:38 AM
Thanks a lot for your quick respond.
I follow your instructions but finally I couldn't get the result I wanted!
As I am afraid that's it's me for not explain correct what I need to do, I put bellow the information I want to work with.
As I said the the names on column A remain the same, the values on column B & C are changing every week (I am using a link to get the values from a different tab).
Present table:
Name Leage Score
Points Points
Matt 9 47
Jono 15 47
Graeme 15 46
George 28 65
Jules 10 36
German 16 58
Antonis 18 55
Wazza 7 40
What I need to do is, every time the figures are changing, a way that automatically the order of the names & the points next to them to be sort it with the top scores on the top of the list.
If somebody have the same leage points, then as a second criteria to be the column C,(the score points).
e.g. (based on figures from the table above)
Jono & Graeme they have both 15 points.
How the table should look with the gigurs bellow should be:
1st George 28 65
2nd Antonis 18 55
3rd German 16 58
4th Jono 15 47
5th Graeme 15 46
6th Jules 10 36
7th Matt 9 47
8th Wazza 7 40
So, how can I setup the formulas to show me Jono on top of Graeme, as he got more score points.
Thanks a lot for all your effort.
Oct 18, 2011 at 02:46 AM
I try that, but doesn't work.
Probably because there isn't actual values in those cells, but links from a different sheet.
And I want the values of this template to be transfered in a new template with the order I mention on my previous message.
It maybe sounds simple, but honestly, I don't know how do it.
However, I am really apreciate your time & the effort you put of trying to solve my problem
Have a nice day!