Excel 2003 Array Formula in Excel 2007

Giganews Newsgroups
Subject: Excel 2003 Array Formula in Excel 2007
Posted by:  Ben C (bcaca…@gmail.com)
Date: Sun, 6 Jul 2008

Hello all,

I am moving from Excel 2003 to Excel 2007. One problem I'm having is
with the following array formula which works in 2003 but returns a
#VALUE! in 2007. Is there something I need to change in my 2007 setup
to make this work?


.... I know there are probably more efficient ways of doing this so I'm
not looking for better solutions. I'm wondering ... why won't it work?
There are 3 array formulas on the spreadsheet and all are returning

Thanks in advance!

Ben Cacace