LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JemyM
 
Posts: n/a
Default A list of the 8 highest results...


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine second (and then third) highest value in a list Scott M. Lyon Excel Discussion (Misc queries) 2 September 12th 05 11:09 PM
How to determine second (and then third) highest value in a list Scott M. Lyon Excel Discussion (Misc queries) 4 September 12th 05 08:51 PM
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 Ed Excel Worksheet Functions 5 September 12th 05 09:48 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Formula to sum and list highest to lowest Brian Excel Worksheet Functions 1 December 11th 04 10:26 PM


All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"