Ok........

In my reply you'll notice that I mentioned ties. Depending on how *YOU*
define what the lowest 5 scores are this can be complicated.

Here is a sample file that demonstrates how to extract names based on the
lowest 5 scores that accounts for *ALL* ties.

http://cjoint.com/?gcutiV1YA5

This file is based on your request for the bottom 5 but as you can see there
are 6 names returned. Try playing around with it by changing the criteria in
the yellow cell and changing the values in column B (include ties) and see
what happens.

Biff

"daddioja" wrote in
message ...

One problem is that if 2 people have duplicate scores, it lists the
first name twice instead of each name.

I have attached a sample. You can see C18 is not right. Thanks for any
help.


+-------------------------------------------------------------------+
|Filename: MATCHING TEST.xls.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4838 |
+-------------------------------------------------------------------+

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