How to tell microsoft that Excel Union Operator doesn't always work

Giganews Newsgroups
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.

Replies