The sample illustrates using an arb. tiebreaker in the criteria col which
enables a full descending sort of the entire source table to be extracted
elsewhere, inclusive ties / multiple ties, if any occurs. You could then
point to (& graph) or read off the top "10" in the extract. Think you could
also point your downstream VLOOKUP or INDEX/MATCH formulas at another key col
with unique values in the extract, eg KPI#?, KPI description?, etc instead of
the scores/points col used in the descending sort.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kirk" wrote:
> 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.