Determining rank change

[loop98]

I was wondering if there was a way to calculate a change in rank from 1 week to another. (see sheet) Ideally to determine a symbol change either positive or negative from the week prior Thanks!

 

[dreid1011]

Are you just looking at week to week comparison, or could it span multiple weeks?

 

[loop98]

Are you just looking at week to week comparison, or could it span multiple weeks?

It would be just week to week

 

[dreid1011]

Is this along the lines of what you want? Col F is sorted based on col C.

Book1
	A	B	C	D	E	F
1	symbol	Week 1 Rank	symbol	Week 2 Rank		Weekly Change
2	CUBI	1	AGO	1		6
3	LPLA	2	ALLY	2		2
4	AX	3	AX	3		0
5	ALLY	4	C	4		6
6	KMPR	5	CRBG	5		8
7	SLM	6	CUBI	6		-5
8	AGO	7	EWBC	7		7
9	XP	8	KMPR	8		-3
10	MARA	9	LPLA	9		-7
11	C	10	MARA	10		-1
12	OMF	11	OMF	11		0
13	WBS	12	SLM	12		-6
14	CRBG	13	WBS	13		-1
15	EWBC	14	XP	14		-6
Sheet6

Cell Formulas
Range	Formula
F2:F15	F2	=FILTER($B$2:$B$15,$A$2:$A$15=C2)-FILTER($D$2:$D$15,$C$2:$C$15=C2)

 

[loop98]

Perfect! Thank you so much for your time

 

[dreid1011]

You're welcome, and happy to help.

 

[StephenCrump]

You could also use a single array formula in F2: =VLOOKUP(C2:C15,A2:B15,2,)-D2:D15

 

[dreid1011]

You could also use a single array formula in F2: =VLOOKUP(C2:C15,A2:B15,2,)-D2:D15

Oh yeah, fair enough. Sometimes the brain skips right over the simple solutions.