WHATS AN ARRAY
 

HI

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

WHATS AN ARRAY
 

Excel help will tell you about array formulae and array constants.
--
David Biddulph

"Srikanth" wrote in message
...
HI

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

WHATS AN ARRAY
 

"Srikanth" wrote in message
...
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.)

WHATS AN ARRAY
 

Hi Stephen,

Thanx for the reply..

"Stephen" wrote:

"Srikanth" wrote in message
...
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.)