Criteria based ranking

Originally Posted by Bo_Ry

How about

=IF(E4="",IF((C4="Urgent")*(D4>=I$2),SUM(N(FREQUENCY(IF((C$4:C$23="Urgent")*(D$4:D$23>=$I$2)*(B$4:B$23>B4)*(E$4:E$23=""),B$4:B$23),B$4:B$23)>0))+2,""),1)

U have put (E$4:E$23="") as a criteria for ranking. Thats smart. I didnt thought about that.
But the problem with this would be it would give rank 1 to any entry in col. E, what if i only want to give rank 1 to "XXX" & "YYY", any other entry means nothing.

Check the sheet for what i meant to say.