Ranking based on criteria

I need help to calculate ranking on the basis of criteria. Col. A has list of item Col. B has price for each item Col. C categorized each item as "urgent" & "Not Urgent". In col. D there is a date for each item. In col. E, i want to rank all "urgent" item on the basis of there Price and on the basis of the date in col.D which should be less than H2.
If the item has same price & is "urgent" then same rank should be given and also the ranking should be on continuous basis i.e., something like 1,2,2,3,4,5, and so on.
Kindly help to derive an excel formula for the same.

I hope you guys understood. My english is bad its not my first language thanks for the help in advance