ExcelBanter - Finding the 3rd largest number in a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Finding the 3rd largest number in a list (https://www.excelbanter.com/excel-worksheet-functions/32863-finding-3rd-largest-number-list.html)

Simon Jefford

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

N Harkawat

=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

Simon Jefford

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

All times are GMT +1. The time now is 11:46 AM.