Finding the 3rd largest number in a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Very Many Thanks
Regards
Simon

N Harkawat said:
=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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula (or code) return the largest number of duplicates in a list. 16
what function do I use for excel to choose the 2nd highest number 2
Find numbers in a range that sum up to a specified number 6
Find Smallest and Largest. 5
Finding the largest match 9
Largest number 4
Finding the largest size in a group 2
Pulling the largest numbers 2

Back
Top