Unique Rank Question

[Loss1003]

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]

1003, you'll have to formulate the question and criteria better.

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

[Bob Phillips]

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)