Max Wrote:
One way, using non-array formulas,
which caters for the possibility of ties in the numbers ..

Assuming table in cols A and B, data from row2 down

Put in D2:
=INDEX(A:A,MATCH(LARGE($F:$F,ROWS($A$1:A1)),$F:$F, 0))
Copy D2 across to E2

Put in F2: =IF(B2="","",B2-ROW()/10^10)
(Leave F1 empty)

Select D2:F2, copy down to F15

Cols D and E will return the full descending sort of what's in cols A
and B
(Col F is the arbitrary tie-breaker)

Just select the desired top 8 from the list within cols D and E


Since the list is sensitive for ties I have tried to go by this
version.

After alot of work I finally got it to work...

My major issue was that I was forced to translate the whole thing to
Swedish, and I did not see the difference between ROW and ROWS at
first. I also managed to write the swedish word for "LARGER" instead of
"LARGE" which caused alot of confusion.

It works now and I can therefore continue my work :) Thanks alot!


--
JemyM
------------------------------------------------------------------------
JemyM's Profile: http://www.excelforum.com/member.php...o&userid=26945
View this thread: http://www.excelforum.com/showthread...hreadid=468387