The formula system I quoted adjusts Top N dynamically..

"andyp161 " wrote in message
...
Thanks for your response Ken. The answer, unfortunately, is yes - the
top bonus is awarded to however many people receive the highest points;
the second highest bonus is awarded to however many people receive the
second highest points, and so forth. Can this be done? Although this
might seem strange, the way the scheme is set up, it is very unlikely
that out of more than 200 hundred employees, more than 2 will receive
equal points...

Many thanks


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