| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
second highest value
cells A1:2200 A2:2100 A3:2200 A4:2200 A5:2200 A6:2180 A7:2190 A8:2200 A9:2100 i know the formula =LARGE(A1:A9,1) i get 2200 which is A1 A3 A4 A5 A8 but i want the second one in value when i type =LARGE(A1:A9,2) i get 2200 but i want 2190 which is A7 to be the second result what formula do i have to use -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=514858 |
| 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 | |||
| In Excel, I need to now how to pick the second highest number in . | Excel Worksheet Functions | |||
Threaded Mode
