It mostly comes with experience.

See if this helps:

http://www.cpearson.com/Excel/ArrayFormulas.aspx

--
Biff
Microsoft Excel MVP


"Jon Dow" wrote in message
...
How do you know when to use ctrl+shift+enter to create an array formula vs
just hitting enter?