Entering an array formula

[Guest]

When I press "CTRL + SHIFT + ENTER" to enter an array formula, nothing
happens. I am not able to enter the array formula. Why does this happen and
how do I make the array formula work?

 

[Guest]

Can we see the formula? What you expect to happen when you enter it?

Mike

 

[Chip Pearson]

The only visible indication you have that a formula is an array formula is
that Excel will display the formula in the formula bar enclosed in curly
braces { }. Beyond that, any response is meaningless without seeing the
actual formula. What is the formula you are using? For information about
array formulas, see www.cpearson.com/Excel/ArrayFormulas.aspx.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)