| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding the 3rd largest number in a list
I have a list of numbers, some possibly equal to others. I need to find the
3rd highest number in the list without using macros. Any help would be greatly appreciated. Thank. Simon |
|
#2
|
|||
|
|||
|
=LARGE(IF(ROW(A1:A11)=MATCH(A1:A11,A1:A11,0),A1:A1 1),3)
array entered (ctrl+shift+enter) assuming that the data begins from cell A1 "Simon Jefford" wrote in message ... I have a list of numbers, some possibly equal to others. I need to find the 3rd highest number in the list without using macros. Any help would be greatly appreciated. Thank. Simon |
|
#3
|
|||
|
|||
|
Very Many Thanks
Regards Simon "N Harkawat" wrote: =LARGE(IF(ROW(A1:A11)=MATCH(A1:A11,A1:A11,0),A1:A1 1),3) array entered (ctrl+shift+enter) assuming that the data begins from cell A1 "Simon Jefford" wrote in message ... I have a list of numbers, some possibly equal to others. I need to find the 3rd highest number in the list without using macros. Any help would be greatly appreciated. Thank. Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
| need help finding a Date range within long list | Excel Worksheet Functions | |||
| finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Linear Mode
