SUMPRODUCT - How can I use does not equal in an array?
 

I am trying to say in an array "does not Equal".

I want it to be everything other than "red" for example.

SUMPRODUCT - How can I use does not equal in an array?
 

<"red"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DG" wrote in message
...
I am trying to say in an array "does not Equal".

I want it to be everything other than "red" for example.

SUMPRODUCT - How can I use does not equal in an array?
 

Thanks Bob. Brainfreeze on my part.

"Bob Phillips" wrote:

<"red"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DG" wrote in message
...
I am trying to say in an array "does not Equal".

I want it to be everything other than "red" for example.

SUMPRODUCT - How can I use does not equal in an array?
 

We all get those <g

Regards

Bob


"DG" wrote in message
...
Thanks Bob. Brainfreeze on my part.

"Bob Phillips" wrote:

<"red"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DG" wrote in message
...
I am trying to say in an array "does not Equal".

I want it to be everything other than "red" for example.