Individual Ranking

[sksanjeev786]

Hi Team,
I need individual ranking like B vs C, B vs D, B vs E for all data and i need all ranking data from Q column onwards

Fidelity_FS_Latesh.xlsx
	B	C	D	E	F	G	H	I	J	K	L
3		Check writing	High-yield savings	Payment services like credit/debit cards and online bill pay	FDIC insured products/services	Peer-to-peer (P2P) payments such as Zelle	Lending products	Monitoring spending and cash flow	Real-time fraud and balance alerts	Budgeting tools	None Of these
4	Ally Bank	12	13	16	20	8	17	12	14	11	55
5	Bank of America/Merrill Lynch	35	20	32	35	14	31	21	26	20	40
6	Capital One	27	21	42	37	11	30	23	32	20	33
7	Cash App	13	16	33	21	43	20	29	25	23	35
8	Charles Schwab	10	13	11	21	5	13	13	14	13	59
9	Citigroup	26	16	33	34	9	27	17	24	17	41
10	Fidelity Investments	11	16	12	25	6	16	14	15	16	54
11	JP Morgan Chase	30	20	35	37	15	30	24	29	21	38
12	PayPal	13	17	36	23	43	18	27	27	20	34
13	SoFi	10	12	15	19	9	16	14	14	14	57
14	Venmo	8	10	21	15	38	9	16	15	13	43
15	Wells Fargo	39	21	36	39	16	32	24	29	23	36
Sheet1

 

[RobP]

Hi, to sort on two columns, you can use "SORTBY" like so.

using just SORTBY, gives you the three columns of data. But, if you wrap it inside CHOOSECOLS, you can pick if you want to see just column 1 (name) and 3 (Q2 data) as I show in second step.

Rgds
Rob

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2			Q1	Q2				Q1	Q2
3		Ally Bank	12	13			Wells Fargo	39	21
4		Bank of America/Merrill Lynch	35	20			Capital One	27	21
5		Capital One	27	21			Bank of America/Merrill Lynch	35	20
6		Cash App	13	16			JP Morgan Chase	30	20
7		Charles Schwab	10	13			PayPal	13	17
8		Fidelity Investments	11	16			SoFi	10	17
9		Citigroup	26	16			Citigroup	26	16
10		JP Morgan Chase	30	20			Cash App	13	16
11		SoFi	10	17			Fidelity Investments	11	16
12		PayPal	13	17			Ally Bank	12	13
13		Venmo	8	10			Charles Schwab	10	13
14		Wells Fargo	39	21			Venmo	8	10
15
16
17							Wells Fargo	39	21		Wells Fargo	21
18							Capital One	27	21		Capital One	21
19							Bank of America/Merrill Lynch	35	20		Bank of America/Merrill Lynch	20
20							JP Morgan Chase	30	20		JP Morgan Chase	20
21							PayPal	13	17		PayPal	17
22							SoFi	10	17		SoFi	17
23							Citigroup	26	16		Citigroup	16
24							Cash App	13	16		Cash App	16
25							Fidelity Investments	11	16		Fidelity Investments	16
26							Ally Bank	12	13		Ally Bank	13
27							Charles Schwab	10	13		Charles Schwab	13
28							Venmo	8	10		Venmo	10
29
Sheet1

Cell Formulas
Range	Formula
G17:I28	G17	=SORTBY(G3:I14,I3:I14,-1,H3:H14,-1)
K17:L28	K17	=CHOOSECOLS(SORTBY(G3:I14,I3:I14,-1,H3:H14,-1),1,3)
Dynamic array formulas.

 

[sksanjeev786]

Hi, to sort on two columns, you can use "SORTBY" like so.

using just SORTBY, gives you the three columns of data. But, if you wrap it inside CHOOSECOLS, you can pick if you want to see just column 1 (name) and 3 (Q2 data) as I show in second step.

Rgds
Rob

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2			Q1	Q2				Q1	Q2
3		Ally Bank	12	13			Wells Fargo	39	21
4		Bank of America/Merrill Lynch	35	20			Capital One	27	21
5		Capital One	27	21			Bank of America/Merrill Lynch	35	20
6		Cash App	13	16			JP Morgan Chase	30	20
7		Charles Schwab	10	13			PayPal	13	17
8		Fidelity Investments	11	16			SoFi	10	17
9		Citigroup	26	16			Citigroup	26	16
10		JP Morgan Chase	30	20			Cash App	13	16
11		SoFi	10	17			Fidelity Investments	11	16
12		PayPal	13	17			Ally Bank	12	13
13		Venmo	8	10			Charles Schwab	10	13
14		Wells Fargo	39	21			Venmo	8	10
15
16
17							Wells Fargo	39	21		Wells Fargo	21
18							Capital One	27	21		Capital One	21
19							Bank of America/Merrill Lynch	35	20		Bank of America/Merrill Lynch	20
20							JP Morgan Chase	30	20		JP Morgan Chase	20
21							PayPal	13	17		PayPal	17
22							SoFi	10	17		SoFi	17
23							Citigroup	26	16		Citigroup	16
24							Cash App	13	16		Cash App	16
25							Fidelity Investments	11	16		Fidelity Investments	16
26							Ally Bank	12	13		Ally Bank	13
27							Charles Schwab	10	13		Charles Schwab	13
28							Venmo	8	10		Venmo	10
29
Sheet1

Cell Formulas
Range	Formula
G17:I28	G17	=SORTBY(G3:I14,I3:I14,-1,H3:H14,-1)
K17:L28	K17	=CHOOSECOLS(SORTBY(G3:I14,I3:I14,-1,H3:H14,-1),1,3)
Dynamic array formulas.

Thanks, Awesome...... thank you so much, sir

Now this is what I needed..!!!