I posted here yesterday when I needed to find the second maximum number
in a range =Large(). However, now I need to find the next unique
maximum number. Is there a way without having to write If statements?
My current approach is:
=IF(LARGE(D:D,2)=MAX,IF(LARGE(D:D,3)=MAX,LARGE(D:D ,4),LARGE(D:D,3)),LARGE(D:D,2))
This is just the beginning so I was wondering if there is a more
effecient way to return the second unique maximum?
Thanks in advance for your help.


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=520105