| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display the Highest, Second Highest, Third Highest and so on...
Hi
Can someone help me to find out and place the highest, second highest, third highest and so on in group of numbers in a sheet? For example: QUESTION: A B C D E F 1004 1004 1004 1518 1517 797 1332 1320 1500 1337 1337 1004 1337 1337 1000 1940 560 1560 I need to find out which is highest, second highest and third highest from A,B & C and the D, E & F columns should display Highest, Second Highest, Third Highest accordingly. Where the numbers are equal, i need a display Equal(AB) or Equal(BC) or Equal (ABC) as the case depends. I might be overthinking on this, but I am just not getting the right formula. If someone could please help on this... please GKB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
| Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
| Help pls! Max func to display value of different cell? | Excel Worksheet Functions | |||
Threaded Mode
