"Conditional" Maximum
 

Hi all,

I have a table where i need to pull out the second maximum value. A
trying to work on something like "Maximum of the table which is lowe
than the Absolute Maximum" I am trying to use DMAX but not sure is th
right way to proceed.

Any suggestions out there???

Many tks

B

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=47978

"Conditional" Maximum
 

Would the LARGE function work for you?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=479781

"Conditional" Maximum
 

thanks a lot!

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=47978