Hi!

Are there any ties involved or the possibility of ties? If so, it can be
kind of complicated depending on how you define the bottom 5.

Assuming no ties:

Names in the range A1:10
Scores in the range B1:B10

Enter this formula in E1:

=SMALL(B$1:B$10,ROWS($1:1))

Enter this formula in D1:

=INDEX(A$1:A$10,MATCH(E1,B$1:B$10,0))

Select both D1 and E1 and copy down to row 5.

Biff

"daddioja" wrote in
message ...

If there is a better way to do this, I am certainly open to suggestions,
but here it is.

I have 2 worksheets. Worksheet 1 has the master set of data. There is a
list of people with scores for each one in a variety of games.

On worksheet 2, I want to list the bottom 5 scores in each game with
the name of the person next to each score. I can identify the lowest 5
scores with the small function. I want sheet 2 to display the name that
is in the cell next to the lowest score found on sheet 1. The name can
be displayed in the same cell or in an adjacent cell on sheet 2. Hope
this problem description makes sense.

Thanks for any help.


--
daddioja
------------------------------------------------------------------------
daddioja's Profile:
http://www.excelforum.com/member.php...o&userid=35024
View this thread: http://www.excelforum.com/showthread...hreadid=547728