Ranking sub sections question

[Harryh217]

Hello, I am currently struggling on how I can rank a subsection within a section based on a #. To make this easier, I will explain it like this. I have 4 separate "portfolios" in column "I". I have Different sub customers within those portfolios in column "K". I would like to rank these sub customers by portfolio by the numbers I have calculated on column "AL." Would this be possible?

 

[Eric W]

Welcome to the forum.

I'm assuming that the higher the number in AL, the better the ranking. If so, consider:

	I	J	K	AK	AL	AM	AN
1	Portfolio		Customer		Score		Ranking within portfolio
2	A		Hal		37		6
3	B		Iris		72		1
4	C		Joe		4		6
5	A		Kim		78		1
6	B		Lou		58		4
7	C		Mary		75		3
8	D		Nate		57		2
9	A		Olly		45		4
10	A		Pam		37		6
11	B		Ralph		35		5
12	A		Sara		61		2
13	C		Tanya		10		5
14	C		Ulysses		83		2
15	D		Vikki		4		3
16	A		Walt		52		3
17	B		Xavier		61		3
18	A		Yolanda		11		8
19	C		Zack		32		4
20	D		Amy		93		1
21	C		Bob		98		1
22	B		Cindi		63		2
23	A		Dan		23		7

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula AN2 =COUNTIFS($I$2:$I$23,I2,$AL$2:$AL$23,">="&AL2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>