Hi Terry,

If you sort the random results in descending score order, then use the
autofilter if you want to display a partial set of the competitors, such as
the top 10 - you can do that with an autofilter.

"Terry" wrote:

Win XP Pro
MS-Office XP

In a workbook I have a sheet that results in a column of random scores via
"large" formula:
{=large$AZ$4:$AZ$53,ROW(1:1)))}.....
From this "large" formula the results are shown in another sheet from
highest score to lowest scores (eg. 434), including competitors name.
Now I have 2 players with a score of 434 in above mentioned column, using
"index/match functions, but it repeats the fisrt name with 434 instead of 2
different names.
It works OK if scores are all different.

I wonder if I may incorperate "round" function in the "large" formula ??
From a non IT senior citizen...

Regards

Terry