JBoulton Wrote:
Domenic,

You're right. It handles ties. I don't understand the array formula
in E1.
It seems to always evaluate to zero.
...

If correctly set up, it will calculate the ties of the Nth value. I
recently replaced it with an ordinary formula as shown in my reply.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=273740