Ranking based on criteria

Originally Posted by Bo_Ry

Please try at E4

=IF((C4="Urgent")*(D4>H$2),MAX(1,SUM(FREQUENCY(IF((C$4:C$23="Urgent")*(D$4:D$23>$H$2)*(B$4:B$23>B4),B$4:B$23),B4))),"")

Thanks Bo_Ry for your response.

I tried using your formula but i guess its taking account of the maximum function and thus ranking ranking price of approx same value i.e., 3.5-3.44-3.3 with the same rank.

The sheet is attached for your reference.

Thanks for the help