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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"JemyM" wrote in message
...

I have a stylesheet that contains "knowledges".
The list looks something like:

Knowledges:
Accounting 14
Anthropology 25
Archeology 48
Art 35
Astronomy 59
Biology 124
Chemistry 123
Geology 15
History 28
Law 167
Medicine 69
Natural History 89
Pharmacy 198
Physics 20

Note the value next to each "knowledge". This number is a calculated
formula that results in a number between 1-200.

Now, if it's possible, I would like Excel to produce a separate list of
the eight knowledges with the highest values right next to it.

Pharmacy
Biology
Chemistry
etc...

Any way this can be done?

Thanks for all replies, if any.


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