ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Array functions

With an array formula it's possible to perform several calculations and return either one single result or multiple results to several target cells. Array formulas works with two or more sets of values called array arguments. All array arguments must have the same number of rows and columns.
You can make an array formula like this:

  1. Select the cell or the range in which you want to enter the array formula.
  2. Enter the formula like any other worksheet formula (without the brackets).
  3. Press Ctrl+Shift+Enter to update the array formula.

The array formula is now visible in the formula bar within two brackets..

 

Document last updated 1999-08-14 12:44:24      Printerfriendly version

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address