| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT as array formula? | Excel Worksheet Functions | |||
| Sumproduct + Array Function? | Excel Worksheet Functions | |||
| What cells in a array equal my value? | Excel Worksheet Functions | |||
| Another SUMPRODUCT array anomaly | Excel Worksheet Functions | |||
| Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
Linear Mode
