DB's

Resolved · Low Priority · Version 2003

DB's

Dorothy has attended:
Excel Advanced course

by - delegate Dorothy [2 posts] (2008 Jun 26 Thu, 16:57) Reply

What is an array?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: DB's

by - trainer Simon gold contributer [151 posts] (2008 Jul 14 Mon, 15:56) Reply

Hi Dorothy,

Thank you for your question.

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. For example, you can place an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. You can also place an array formula in a single cell and then calculate a single amount. An array formula that resides in multiple cells is called a multi-cell formula, and an array formula that resides in a single cell is called a single-cell formula.

I hope this gives you an insight into what an array is.

Regards

Simon

· Training Budgets In A Bad Economy
· Advanced Excel Training - takes you to the next level
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· From the Classroom to the Corporate World
· Tips to Facilitate Printing of Excel worksheets

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips

Rate this page: