Rank By Criteria

[gcgoode]

So I have a table that looks like this.

Please Login or Register  to view this content.

I want it to rank the CompanyID's by average cost per each policy number. So the output would look like this:

Please Login or Register  to view this content.

Anyone got an idea on how I could achieve this? Any help would be greatly appreciated.

Thank you.

[quekbc]

Perhaps something like this?

Row\Col	A	B	C	D
1	AvgCost	CompanyID	Policy#	Rank
2	25	22	12	2
3	28	23	12	3
4	35	24	12	4
5	21	25	12	1
6	20	22	20	2
7	15	24	20	1
8	13	23	21	1
9	43	24	21	2

Formula in D2: =COUNTIFS($A$2:$A$9,"<=" & $A2,$C$2:$C$9,$C2) copied down.