need ranking

[sksanjeev786]

Hi Team,

I need an individual ranking based on column B to K and column A order change accordingly based on the column B to K low to high.

book3
	A	B	C	D	E	F	G	H	I	J	K
2		AOTC 21-54	AOTC 21-29	AOTC 30-54	Copenhagen Users 21-54	Grizzly	Skoal	Red Seal	Husky	on!	Zyn
3	Have products with the longest total satisfaction	1	2	1	1	1	1	3	10	2	4
4	Are brands you'd be proud to use	2	3	2	4	2	2	7	1	1	2
5	Have the highest quality products	3	1	3	3	4	4	5	9	5	1
6	Satisfies your desire for nicotine	4	7	4	5	3	3	9	2	9	6
7	Have products with the best taste/flavor	5	5	6	9	8	10	13	7	7	8
8	Are brands that understand you	6	8	5	7	6	7	1	5	3	7
9	Are overall popular brands	7	12	7	6	5	5	8	8	15	10
10	Are a good value	8	4	8	10	7	6	4	4	6	3
11	Have great packaging	9	9	10	11	10	13	14	11	10	16
12	Help you feel more connected to other adults who use the brand	10	14	9	12	12	11	11	16	14	15
13	Are best for situations when you prefer not to use other tobacco products	11	10	11	15	14	16	12	19	16	9
14	Have a wide variety of flavors	12	11	13	13	15	12	6	17	8	12
15	Has the freshest product**	13	16	12	2	9	8	18	15	19	18
16	Have a strong heritage	14	19	14	14	13	9	10	12	17	17
17	Are popular among adult tobacco social media influencers	15	13	16	16	16	14	15	3	12	14
18	Has the most premium cans/tins**	16	18	15	8	11	15	16	18	18	19
19	Has the ideal pouch size*	17	6	17	17	17	17	2	6	11	5
20	Is easiest to carry around in any environment*	18	15	19	18	18	19	17	13	4	11
21	Has the most nicotine strength options*	19	17	18	19	19	18	19	14	13	13
Sheet1

 

[Cubist]

By what aggregate method (e.g. sum, max, average, ect...) do you want to apply to B-K to acquire the individual ranking?

 

[sksanjeev786]

By what aggregate method (e.g. sum, max, average, ect...) do you want to apply to B-K to acquire the individual ranking?

yes i need individual ranking from B to K along with Colum A (AB, AC,AD,DE ) ranking

 

[Cubist]

Are you sorting the rows A3:A21) or the columns B-K? Not really understanding your sorting crieria.

 

[sksanjeev786]

Are you sorting the rows A3:A21) or the columns B-K? Not really understanding your sorting crieria.

Hi Cubist,

I would like to short the data from B to K (A3 to A21) should apply ranking individual ( like AB, AC, AD etc column )

 

[Cubist]

Not sure what you mean but maybe this.

SplitNameEmail.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1		AOTC 21-54	AOTC 21-29	AOTC 30-54	Copenhagen Users 21-54	Grizzly	Skoal	Red Seal	Husky	on!	Zyn
2	Have products with the longest total satisfaction	1	2	1	1	1	1	3	10	2	4
3	Are brands you'd be proud to use	2	3	2	4	2	2	7	1	1	2
4	Have the highest quality products	3	1	3	3	4	4	5	9	5	1
5	Satisfies your desire for nicotine	4	7	4	5	3	3	9	2	9	6
6	Have products with the best taste/flavor	5	5	6	9	8	10	13	7	7	8
7	Are brands that understand you	6	8	5	7	6	7	1	5	3	7
8	Are overall popular brands	7	12	7	6	5	5	8	8	15	10
9	Are a good value	8	4	8	10	7	6	4	4	6	3
10	Have great packaging	9	9	10	11	10	13	14	11	10	16
11	Help you feel more connected to other adults who use the brand	10	14	9	12	12	11	11	16	14	15
12	Are best for situations when you prefer not to use other tobacco products	11	10	11	15	14	16	12	19	16	9
13	Have a wide variety of flavors	12	11	13	13	15	12	6	17	8	12
14	Has the freshest product**	13	16	12	2	9	8	18	15	19	18
15	Have a strong heritage	14	19	14	14	13	9	10	12	17	17
16	Are popular among adult tobacco social media influencers	15	13	16	16	16	14	15	3	12	14
17	Has the most premium cans/tins**	16	18	15	8	11	15	16	18	18	19
18	Has the ideal pouch size*	17	6	17	17	17	17	2	6	11	5
19	Is easiest to carry around in any environment*	18	15	19	18	18	19	17	13	4	11
20	Has the most nicotine strength options*	19	17	18	19	19	18	19	14	13	13
21
22	Have products with the longest total satisfaction	1	2	1	1	1	1	3	10	2	4
23	Are brands you'd be proud to use	2	3	2	4	2	2	7	1	1	2
24	Have the highest quality products	3	1	3	3	4	4	5	9	5	1
25	Satisfies your desire for nicotine	4	7	4	5	3	3	9	2	9	6
26	Have products with the best taste/flavor	5	5	6	9	8	10	13	7	7	8
27	Are brands that understand you	6	8	5	7	6	7	1	5	3	7
28	Are overall popular brands	7	12	7	6	5	5	8	8	15	10
29	Are a good value	8	4	8	10	7	6	4	4	6	3
30	Have great packaging	9	9	10	11	10	13	14	11	10	16
31	Help you feel more connected to other adults who use the brand	10	14	9	12	12	11	11	16	14	15
32	Are best for situations when you prefer not to use other tobacco products	11	10	11	15	14	16	12	19	16	9
33	Have a wide variety of flavors	12	11	13	13	15	12	6	17	8	12
34	Has the freshest product**	13	16	12	2	9	8	18	15	19	18
35	Have a strong heritage	14	19	14	14	13	9	10	12	17	17
36	Are popular among adult tobacco social media influencers	15	13	16	16	16	14	15	3	12	14
37	Has the most premium cans/tins**	16	18	15	8	11	15	16	18	18	19
38	Has the ideal pouch size*	17	6	17	17	17	17	2	6	11	5
39	Is easiest to carry around in any environment*	18	15	19	18	18	19	17	13	4	11
Sheet7

Cell Formulas
Range	Formula
A22:K40	A22	=SORTBY(A2:K20,B2:B20,1,C2:C20,1,D2:D20,1,E2:E20,1,F2:F20,1,G2:G20,1,H2:H20,1,I2:I20,1,J2:J20,1,K2:K20,1)
Dynamic array formulas.