PDA

View Full Version : Unique Rank Question



Loss1003
12-30-2013, 12:14 PM
I'm trying to Rank a list and than re-rank the list while excluding certain (or by Criteria) itemsVendor Co Cost Fee RankVertox 500 4BV 1520 3A&S 3057 2ISA 5000 1GCC 250 5GSI 147 6 Excluded Vendors ISA A&S Vendor Co Cost Fee RankBV 1520 1Vertox 500 2GCC 250 3GSI 147 4

SamT
12-30-2013, 01:22 PM
1003, you'll have to formulate the question and criteria better.

also, what do you mean by "Rank a list?"

Bob Phillips
12-30-2013, 03:18 PM
Assuming that the items to be not ranked are in a named range called exclusions, this array formula should do it

=IF(ISNUMBER(MATCH(A2,exclusions,0)),"",SUM(--(B2<IF(NOT(ISNUMBER(MATCH($A$2:$A$7,exclusions,0))),$B$2:$B$7,0)))+1)