Thanks Vasant,

got it to work with three columns, but it broke with 4...I think I'll
just try the other way.

tim

Vasant Nanavati wrote:
How about this?

=SUM(RANK($B2:$D2,$B$2:$D$11))-COUNT($B$2:$D$11)

array-entered.