Thread: Ranking and Assigning

Write in S5 =LARGE($B$4:$P$18,ROW(A1)) and pull down.

Perhaps you could do the following...

List Projects A, B, C, ... to O in U5:U19

Then

S5: 
=MAX(IF(ISNA(MATCH($A$4:$A$18,$T$4:$T4,0)),INDEX($B$4:$P$18+(ROW($B$4:$B$18)/100),0,ROWS(S$5:S5))))
confirmed with CTRL + SHIFT + ENTER
copied down to S19
Apply a Number Format with 0 Decimal Places to range S5:S19

T5:
=INDEX($A:$A,MOD($S5,1)*100)
copied down to T19

Does that work for you ?

It may well be that your decision making needs to be more complex than this but in essence Project A will be assigned to the highest bidder, Project B to the highest bidder once Team assigned to A has been discounted and so on and so forth...
in essence this means Project O is simply assigned to whomever is left "unallocated" at that point...
(as I say this be overly simplistic for you... then again it may do what you require)

EDIT:
and if you want to see how the "winning" bid "ranks" compared to all originally submitted bids (ie before teams were withdrawn from the calc. by virtue of winning prior projects) then you could use an adjacent column such that:

V5: =RANK(INT($S5),INDEX($B$4:$P$18,0,ROWS(V$5:V5)))
copied down to V18