WHATS AN ARRAY

[Srikanth]

HI

CAN ANY ONE TELL ME WHATS AN ARRAY AND HOW TO USE IT.

 

[David Biddulph]

Excel help will tell you about array formulae and array constants.

 

[Stephen]

HI

CAN ANY ONE TELL ME WHATS AN ARRAY AND HOW TO USE IT.

An array is a block of cells.

You can have one-dimensional arrays:
A column (A:A) or part of a column (A1:A5).
A row (3:3) or part of a row (E3:J3).

You can have a two-dimensional array:
For example, C7:E12 is a 3x6 array as it contains 3 columns and 6 rows.

You have already used one-dimensional arrays in SUMPRODUCT.

The simplest example of using a two-dimensional array is
=SUM(A1:B2)
This simply adds up the four values in A1, A2, B1 and B2.

Another example of using a two-dimensional array (E10:F19) is:
=VLOOKUP(A1,E10:F19,2,FALSE)
This takes the value in A1, looks down the first column of the array E10:F19
to see if there is a match, and if there is returns the corresponding data
from column 2 of the array. ("FALSE" tells it only to look for an exact
match.)

 

[Srikanth]

Hi Stephen,

Thanx for the reply..

An array is a block of cells.

You can have one-dimensional arrays:
A column (A:A) or part of a column (A1:A5).
A row (3:3) or part of a row (E3:J3).

You can have a two-dimensional array:
For example, C7:E12 is a 3x6 array as it contains 3 columns and 6 rows.

You have already used one-dimensional arrays in SUMPRODUCT.

The simplest example of using a two-dimensional array is
=SUM(A1:B2)
This simply adds up the four values in A1, A2, B1 and B2.

Another example of using a two-dimensional array (E10:F19) is:
=VLOOKUP(A1,E10:F19,2,FALSE)
This takes the value in A1, looks down the first column of the array E10:F19
to see if there is a match, and if there is returns the corresponding data
from column 2 of the array. ("FALSE" tells it only to look for an exact
match.)