Leo Heuser wrote...
"Harlan Grove" skrev i en meddelelse
...
Also it requires that column H contain only the bonus amounts
and nothing else. If there were 12 distinct point amounts, and
if cell H13 happened to contain "foo", then the person(s) with
the lowest points would have "foo" appear as their bonus.


Of course. It should have followed from my remark "In H2 and
down bonus points.", that column H was to be used for bonuses
only. Should anybody get a "foo", he/she can always look at it
as an added bonus

We seem to have a difference of opinion regarding the level of
explicitness needed concerning the contents of column H. Note that you
could have named the bonus range (including an explicit 0 as the
'lowest' bonus amount) BonusRange and used

INDEX(BonusRange,MIN(COUNT(BonusRange),SUMPRODUCT( ...)+1))

and left the remainder of column H free for other uses.


---
Message posted from http://www.ExcelForum.com/