Thread: How do I search for the second largest value in the array?
View Single Post
  #2  
Old April 22nd, 2010, 08:58 AM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
  
Posts: 8,714
Default How do I search for the second largest value in the array?
=LARGE(A:A,2)
=LARGE(A:A,3)

=LARGE(1:1,2)
=LARGE(1:1,3)
--
David Biddulph


"Golf" wrote in message
...
How do I search for the second (or third and so on) largest value in the
array either in column or row?