Entering Array Functions

[Guest]

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?

 

[Ron Rosenfeld]

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