Does that not mean that you need a lookup table of scores and bonus points?
After determining the Top N list of names and their scores, you can lookup
the bonus points associated with the scores from the lookup table, using a
VLOOKUP() formula.

"andyp161 " wrote in message
...
To clarify, the original numbers are to remain where they are; bonus
points are to be inserted in the cells to the right of the four highest
numbers.

Regards


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