Returning 2nd value

[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.

 

[Bob Phillips]

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)

 

[Frank Kabel]

Hi Trey
have a look at LARGE/SMALL:
=LARGE(your_range,2)

HTH
Frank