That gets somewhat harder, because where do you stop? Is the bonus money
unlimited? If 4 people match the highest score, 2 people match the second
highest, and 3 people match the third highest score, do you give away 4 x Top
prize, 2 x 2nd prize and 3 x 3rd prize?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"andyp161 " wrote in message
...
Ken, this works brilliantly except for one thing - if, for example, two
people have earned the highest number of points, they should both
receive the highest bonus points, and similarly for 2nd, 3rd and
fourth; with the formula you kindly put forward, only for bonus points
are matched in total?

Kind regards


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.718 / Virus Database: 474 - Release Date: 09/07/2004