Ranking based on criteria

Originally Posted by FlameRetired

Hello andrei461. Welcome to the forum.

As far as the "Urgent"/"Non Urgent" ranking goes try array entering this formula in E4 and fill down If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

=IFERROR(MATCH(IF(C4="Urgent",B4),LARGE(IF($C$4:$C$23="Urgent",$B$4:$B$23),ROW(INDIRECT("1:"&COUNTIF($C$4:$C$23,"Urgent")))),0),"")

As for the inclusion of date as criteria for rank I think we will need more information. Please attach another workbook to your next post with the hand typed results of what you expect with that criteria in mind. It might help us to understand better.

i have attached a sheet for your refernce. its a nice approach for using array entered formula. Ur formula takes into criteria of ranking "Urgent" item on the basis of decreasing price. I want to include a third criteria that will take account of Col. D values and check it with H2. If dates in col. D >= H2 then only i want to rank "Urgent" on the basis of decreasing "Price".

Thanks for your help