Try this:
=LARGE(H:H,2)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"anyways" wrote in
message ...
Hey, is there a way to set the max() function to find for like the
second bigger number in a list instead of the bigest one?
if not, is there a way to to put an "except" fonction while selecting
data?
ex: H:H except(H85) or H:H\H85
This way I could do somehting like MAX(H:H except(H85(which would be
the bigest number in the column))
This function would then show me the second biffer number in H:H as I
rejected the H:85
hope you understand, please reply fast, thanks
--
anyways
------------------------------------------------------------------------
anyways's Profile:
http://www.excelforum.com/member.php...o&userid=31815
View this thread:
http://www.excelforum.com/showthread...hreadid=515377