| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering an array formula
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Entering an array formula
Can we see the formula? What you expect to happen when you enter it?
Mike "wthawaii" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering IF formula | Excel Worksheet Functions | |||
| entering formula in a numeric array | Excel Discussion (Misc queries) | |||
| entering as an array | Excel Discussion (Misc queries) | |||
| Entering Array Functions | Excel Discussion (Misc queries) | |||
| Entering array in single cell | Excel Discussion (Misc queries) | |||
Linear Mode
