Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to determine second (and then third) highest value in a list | Excel Discussion (Misc queries) | |||
How to determine second (and then third) highest value in a list | Excel Discussion (Misc queries) | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Formula to sum and list highest to lowest | Excel Worksheet Functions |