Priortisation, without skipping ranks

[surkdidat]

I have the following formula, which is ranking items correctly. However, if more than 1 item has the same score, then it will "skip" a rank.
FOr example, if I have scores of 20, 19, 18, 18, 17 it would score as follows

1st 20
2nd 19
3rd 18, 18
5th 17

What I need (ideally) is to have it that as in the above example 17 would be 4th (the 18s still at 3rd, 19 still ranked second etc)

=IF(AK2="","",IF(K2="PIPELINE",COUNTIFS($H$2:$H$749,H2,$AK$2:$AK$749,">"&AK2)+1,""))))

AK is the score column
K is the status column
H is a specific department

 

[mrshl9898]

Not quite following your setup.

But with scores in A2:A7: =RANK(A2,$A$2:$A$7)+COUNTIF(A$2:A2,A2)-1 copied down to get the rank

 

[surkdidat]

Hi there, apologies that has not quite done what I need - I have put a table below, hopefully to clarify:

=IF(AK2="","",IF(K2="PIPELINE",COUNTIFS($H$2:$H$749,H2,$AK$2:$AK$749,">"&AK2)+1,""))))

COLUMN C - (Priority)	COLUMN H - (Development Area)	COLUMN AK - (Priority Score)	CURRENT FORMULA	REQUIRED SOLUTION
(Formula will go here)	AAA	20	1	1	Currently, correctly looking up the department (AAA) - Correct Position
	AAA	20	1	1	Currently, correctly looking up the department (AAA) - Correct Position
	BBB	21	1	1	Correct
	BBB	20	2	2	Correct
	CCC	10	1	1	Correct
	AAA	19	3	2	Currently, correctly looking up the department (AAA) - Ranking 3rd, needs to be ranked 2nd in Dept AAA, as score is 2nd lowest.

Not quite following your setup.

But with scores in A2:A7: =RANK(A2,$A$2:$A$7)+COUNTIF(A$2:A2,A2)-1 copied down to get the rank