OK, another oddity

Bob Umlas

New member
Joined
Mar 22, 2011
Messages
10
Reaction score
0
Points
0
Age
80
Location
New York
Array enter ANY formula in A1, say =0 (ctrl/shift/enter)
then select A1:B2, merge cells.
Now re-enter the array-formula in A1.
You get a strange message: "Array formulas are not valid in Merged Cells".

Well it was fine before I RE-entered it!:confused2::confused2::confused2::becky:
 
Top