"tuph" skrev i en
meddelelse ...

Correct. Ideally I would like to rank the other duplicates, also, but
this isn't as important.


--
tuph


I guess, that the above wasn't an answer to my "question"?

Anyway, try one of these two array formulae instead of the ones I supplied:

Highest budget at top:

=RANK(G2,$G$2:$G$11)+IF(G2=0,MATCH(D2,LARGE(($G$2: $G$11=0)*
$D$2:$D$11,ROW(INDIRECT("1:"&COUNTIF($G$2:$G$11,0) ))),0)-1,COUNTIF($G$2:G2,G2)-1)


Highest budget at bottom:
=RANK(G2,$G$2:$G$11)+IF(G2=0,MATCH(D2,SMALL(($G$2: $G$11=0)*
$D$2:$D$11,ROW(INDIRECT("1:"&COUNTIF($G$2:$G$11,0) ))+COUNTIF($G$2:$G$11,"<"&0)),0)-1,COUNTIF($G$2:G2,G2)-1)

Both to be entered with <Shift<Ctrl<Enter, also if edited later.

--
Best regards
Leo Heuser

Followup to newsgroup only please.