Creating an array

Hello Faye,

Thank you for the post,

To create an array formula, select the range of cells or individual cells in different areas of the worksheet, to which you wish to apply the same formula, in the first cell (highlighted) type the formula, then hold down the CTRL and SHIFT keys and press Enter. This will apply the formula to the entire range. You can identify an array formula by {} curly braces.

I'm not too sure what the F,S and E are all about, I will have to check the training manual on the CD.

There are some functions such as Data>Table command which will create an array, usually these can also be identified by the {} curly braces which surround each result cell formula.


I hope that helps, regards Pete