|Subject:||How to tell microsoft that Excel Union Operator doesn't always work|
|Posted by:||UncleBob (UncleB…@microsoft.com)|
|Date:||Fri, 21 May 2004|
What is the best way to report a bug to microsoft?
Cell A1 through F1 contain the colors red, blue,
green, yellow, pink, purple
Cell a2 contains green
Cell b2 contains =or(a2=(a1:f1)) as a control
shift enter array formula.
Cell c2 contains =or(a2 = (a1:b1,d1:f1)) CSE
Cell b2 works fine, but cell c2 does not work.
Seems to me that the Union operator (which is a ,)
should work but does not.