Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Entering Array Functions
What are the exact mechanics of entering arrays using Control, Shift, Enter?
I understand that it's nesseccary to let Exel know it's an Array Function, but I don't seem to have the order right, so it doesn't work. Do I enter the formula, then hit Control Shift Enter, or do I hit it first, then enter the formula? |
#2
|
|||
|
|||
On Sun, 28 Aug 2005 07:56:02 -0700, Jaytee
wrote: What are the exact mechanics of entering arrays using Control, Shift, Enter? I understand that it's nesseccary to let Exel know it's an Array Function, but I don't seem to have the order right, so it doesn't work. Do I enter the formula, then hit Control Shift Enter, or do I hit it first, then enter the formula? After you type or paste in the formula, you would normally just hit <enter. If it is an array formula, first hold down the <ctrl and <shift keys together. While holding down both of these keys, hit <enter and release it. You can release the other two keys either simultaneously or after. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array functions ARGHH! | Excel Discussion (Misc queries) | |||
Entering array in single cell | Excel Discussion (Misc queries) | |||
array functions and ISNUMBER() | Excel Worksheet Functions | |||
Array Functions from Alan Beban | Excel Worksheet Functions | |||
Array Functions - Two Questions | Excel Worksheet Functions |