Biff... Thanks for the Reply

Do you think you could write the eqation as it applies to your
example?

A B C D E
100 99 78 85 100

Where the value of 100 is in Cells A2 & E2.

I couldn't even get it to work with a simplified spreadsheet. I cannot
see how the array works???

Thanks

Scott


--
smckie
------------------------------------------------------------------------
smckie's Profile: http://www.excelforum.com/member.php...o&userid=32595
View this thread: http://www.excelforum.com/showthread...hreadid=523973