Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
array formulas

ResolvedVersion 2010

Nestor has attended:
Excel Intermediate course

Array formulas

How do array formulas work? some general information or explanation.

RE: Array formulas

Hello Nestor,

Array formulas in Excel are considered "Power Excel" funcions that allow calculations to include muliple levels and ranges of calculations to be performed. There is not enough room here to show examples and full explainations, so I've included a link to an excellent overview.

http://office.microsoft.com/en-us/excel-help/guidelines-and-examples-of-array-formulas-HA010228458.aspx

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Fri 23 Dec 2011: Automatically marked as resolved.

Excel tip:

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.