Returning 2nd value

  • Thread starter Thread starter Trey
  • Start date Start date
T

Trey

Is there a way to return the second value in a range of
values? I can get the first and last values with max and
min, but I'm also trying to get the second largest. My
spreadsheet includes multiple rows and columns, so rank
doesn't seem to be pratical. Thanks.
 
Trey,

=LARGE(A1:A2,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top