Thanks people, but i'm using large to find to the top ten of 5 different KPIs
which i then plan to graph along with the value i'm looking up. At the
moment I'm sorting which is what i'm trying to avoid because the graphs
change each time i sort.

"Max" wrote:

"Kirk" wrote:
I have an array that I'm using LARGE to find the top ten values. I want to
use VLOOKUP, or what ever else suits, on these top ten values to find other
values in the array. This works fine until the top ten that LARGE yields has
2 or more values the same. How would I eliminate a value that has already
been returned/looked up in order to find the next in line?

One way ..
Try this sample from my archives collection (full details inside):
http://savefile.com/files/5659668
Simple Auto-Sort Example.xls
(Auto-sort table in descending order)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---