I am trying to pull the top 10 values from row B and the name
associtated with that value in row A. I will be doing the same things
with Rows C and A, and the again with Rows D and A, so I can't simply
sort.

Example:
Name Points 3's FT's
Greg 24.5 23 2
Matt 25 11 3
Tom 22.3 22 4
Dave 15.5 15 5

I need to return for points:
Top Scorer's
Matt 25
Greg 24.5
Tom 22.3
Dave 15.5

I would then be returning the same situation for top 5 in 3's and the
top 5 in FT's.

I tried using the large() function to pull out the top 10 in Points,
but did not no how to pull the names with them.


--
gdecat
------------------------------------------------------------------------
gdecat's Profile: http://www.excelforum.com/member.php...o&userid=24302
View this thread: http://www.excelforum.com/showthread...hreadid=490452