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

=LARGE(IF(ROW(A1:A11)=MATCH(A1:A11,A1:A11,0),A1:A11),3)
array entered (ctrl+shift+enter)
assuming that the data begins from cell A1

"Simon Jefford" <SimonJefford@discussions.microsoft.com> wrote in message
news:3A355D59-D2EB-4BA3-8794-7939D2908D52@microsoft.com...
>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

Very Many Thanks
Regards
Simon

"N Harkawat" wrote:

> =LARGE(IF(ROW(A1:A11)=MATCH(A1:A11,A1:A11,0),A1:A11),3)
> array entered (ctrl+shift+enter)
> assuming that the data begins from cell A1
>
> "Simon Jefford" <SimonJefford@discussions.microsoft.com> wrote in message
> news:3A355D59-D2EB-4BA3-8794-7939D2908D52@microsoft.com...
> >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
>
>
>