Excel formula to sort data

[keranali]

Good Day all I am looking for an excel formula to sort this data by largest to smallest... Sorting row B and inputting in Row C the values of Row A e.g below

Ying 1.4.2.xlsm
	K	L	M	N	O	P	Q	R	S	T
28	A	1	2	3	4	5	6	7	8	9
29	B	13	14	15	11	14	13	3	10	11
30	C	3	2	5	1	6	4	9	8	3
Overview

Cell Formulas
Range	Formula
L29	L29	=N18+P18+R18+T18
M29	M29	=N19+P19+R19+T19
N29	N29	=N20+P20+R20+T20
O29	O29	=N21+P21+R21+T21
P29	P29	=N22+P22+R22+T22
Q29	Q29	=N23+P23+R23+T23
R29	R29	=N24+P24+R24+T24
S29	S29	=N25+P25+R25+T25
T29	T29	=N26+P26+R26+T26

 

[awoohaw]

So. are you saying your expected result is:
11,14,13,11,13,15,14,10,3 ?

 

[keranali]

Thanks for your response This is what i want the result to look like

Ying 1.4.2.xlsm
	L	M	N	O	P	Q	R	S	T
30	3	2	5	1	6	4	9	8	3
31	15	14	14	13	13	11	11	10	5
Overview

Data Table to sort

Ying 1.4.2.xlsm
	L	M	N	O	P	Q	R	S	T
28	1	2	3	4	5	6	7	8	9
29	13	14	15	11	14	13	3	10	11
Overview

Cell Formulas
Range	Formula
L29	L29	=N18+P18+R18+T18
M29	M29	=N19+P19+R19+T19
N29	N29	=N20+P20+R20+T20
O29	O29	=N21+P21+R21+T21
P29	P29	=N22+P22+R22+T22
Q29	Q29	=N23+P23+R23+T23
R29	R29	=N24+P24+R24+T24
S29	S29	=N25+P25+R25+T25
T29	T29	=N26+P26+R26+T26

 

[awoohaw]

so much confusion?
No 7 and two 3's in row 30,
You have a 3 in R29 that is not in row 31.

 

[keranali]

Yes I see the error sorry about that here is the revised version

Ying 1.4.2.xlsm
	L	M	N	O	P	Q	R	S	T
28	1	2	3	4	5	6	7	8	9
29	5	7	9	9	14	13	13	9	5
30	5	6	7	3	4	8	2	1	9
Overview

Cell Formulas
Range	Formula
L29	L29	=N18+P18+R18+T18
M29	M29	=N19+P19+R19+T19
N29	N29	=N20+P20+R20+T20
O29	O29	=N21+P21+R21+T21
P29	P29	=N22+P22+R22+T22
Q29	Q29	=N23+P23+R23+T23
R29	R29	=N24+P24+R24+T24
S29	S29	=N25+P25+R25+T25
T29	T29	=N26+P26+R26+T26

 

[awoohaw]

Yes I see the error sorry about that here is the revised version

Ying 1.4.2.xlsm
	L	M	N	O	P	Q	R	S	T
28	1	2	3	4	5	6	7	8	9
29	5	7	9	9	14	13	13	9	5
30	5	6	7	3	4	8	2	1	9
Overview

Cell Formulas
Range	Formula
L29	L29	=N18+P18+R18+T18
M29	M29	=N19+P19+R19+T19
N29	N29	=N20+P20+R20+T20
O29	O29	=N21+P21+R21+T21
P29	P29	=N22+P22+R22+T22
Q29	Q29	=N23+P23+R23+T23
R29	R29	=N24+P24+R24+T24
S29	S29	=N25+P25+R25+T25
T29	T29	=N26+P26+R26+T26

still confused. What happened to Row 31 ?

 

[awoohaw]

maybe this works for you:

Mr excel questions 36.xlsm
	A	B	C	D	E	F	G	H	I
28
29	1	2	3	4	5	6	7	8	9
30	5	7	9	9	14	13	13	9	5
31	5	6	7	3	4	8	2	1	9
32	14	13	13	9	9	9	7	5	5
33
34	5	6	7	3	4	8	2	1	9
35	14	13	13	9	9	9	7	5	5
Sheet1

Cell Formulas
Range	Formula
A32:I32	A32	=HLOOKUP(A31,$A$29:$I$30,2,FALSE)
A34:I35	A34	=SORT($A$29:$I$30,2,-1,1)
Dynamic array formulas.

 

[Fluff]

Is this what you mean

Fluff.xlsm
	L	M	N	O	P	Q	R	S	T
28	1	2	3	4	5	6	7	8	9
29	13	14	15	11	14	13	3	10	11
30	3	2	5	1	6	4	9	8	7
Master

Cell Formulas
Range	Formula
L30:T30	L30	=SORTBY(L28:T28,L29:T29,-1)
Dynamic array formulas.

 

[keranali]

Thanks guys for the help worked perfectly.

 

[Fluff]

Glad we could help & thanks for the feedback.