#VALUE! could indicate you did not array-enter the formula.

CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 08:13:36 -0700 (PDT), Mark767
wrote:

Bernie,

I am still getting the #Value! error.

I even went as far as making a new spreadsheet with just numbers in
each row and column and trying it again using your formula above in a
new worksheet all with the same names. Again the #Value! error, which
is strange because it was all numbers so I am not sure how the data
types could be mixed.

Any ideas ?


Mark.