| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the highest values
How do you find the 1st, 2nd, .... nth highest value of a given row or column of cells filled with numbers? Say I have a bunch of numbers in A1 through Z1. I want the biggest 5 to appear on another sheet as A1, A2, A3, A4, and A5. -- bob135 ------------------------------------------------------------------------ bob135's Profile: http://www.excelforum.com/member.php...o&userid=33388 View this thread: http://www.excelforum.com/showthread...hreadid=532137 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| Finding (Multiple) Highest Values in Column | Excel Worksheet Functions | |||
| Finding number of values in a range on a per year basis | Excel Worksheet Functions | |||
| Min values in a list of numbers | Excel Worksheet Functions | |||
Threaded Mode
