Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WHATS AN ARRAY
HI
CAN ANY ONE TELL ME WHATS AN ARRAY AND HOW TO USE IT. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
whats it do | Excel Discussion (Misc queries) | |||
Whats the best way to... | Excel Worksheet Functions | |||
Whats the best way to... | Excel Worksheet Functions | |||
Whats the best way to... | Excel Worksheet Functions | |||
Whats Wrong with this?? | Excel Worksheet Functions |