View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Entering an array formula

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)


"wthawaii" wrote in message
...
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?