software

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 quot;exceptquot; 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: www.excelforum.com/member.php...oamp;userid=31815
View this thread: www.excelforum.com/showthread...hreadid=515377Try this:

=LARGE(H:H,2)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===quot;anywaysquot; gt; 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 quot;exceptquot; 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:
www.excelforum.com/member.php...oamp;userid=31815
View this thread: www.excelforum.com/showthread...hreadid=515377

Perhaps the LARGE function:

=LARGE(H:H,2)

The second arugment of the function is where you set which large value
you want. The example above returns the 2nd largest value in Col_H.

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=515377
yeah! thanks a lot guys--
anyways
------------------------------------------------------------------------
anyways's Profile: www.excelforum.com/member.php...oamp;userid=31815
View this thread: www.excelforum.com/showthread...hreadid=515377