Here's a sample file based on my example:

http://s60.yousendit.com/d.aspx?id=2...F0PR9RZA0ZHON6

Biff

"smckie" wrote in
message ...

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