Hi Gyanesh,
The Table function should be a customised function and can be used to enter
with Ctrl + Shift + Enter key combination of keyboard. If you want to know
about Array formula, below is the help.
Below is what I got when I searched "Array formula" in Excel 2003 in -built
help:-
About array formulas and array constants <javascript:AlterAllDivs('none');>
An array formula can perform multiple calculations and then return either a
single result or multiple results. Array formulas act on two or more sets of
values known as array arguments. Each array argument must have the same
number of rows and columns. You create array formulas in the same way that
you create other formulas, except you press CTRL+SHIFT+ENTER to enter the
formula.
Array constants can be used in place of references when you don't want to
enter each constant value in a separate cell on the worksheet.
Some of the built-in functions are array formulas, and must be entered as
arrays to get the correct results.
[image: Hide]Using an array formula<javascript:ToggleDiv('divExpCollAsst_1')>
*To calculate a single result* This type of array formula can simplify a
worksheet model by replacing several different formulas with a single array
formula.
For example, the following calculates the total value of an array of stock
prices and shares, without using a row of cells to calculate and display the
individual values for each stock.
[image: Array formula that produces a single result]
Array formula that produces a single result
When you enter the formula ={SUM(B2:D2*B3:D3)} as an array formula, it
multiples the Shares and Price for each stock, and then adds the results of
those calculations together.
*To calculate multiple results* Some worksheet functions return arrays of
values, or require an array of values as an argument. To calculate multiple
results with an array formula, you must enter the array into a range of
cells that has the same number of rows and columns as the array arguments.
For example, given a series of three sales figures (in column B) for a
series of three months (in column A), the TREND function determines the
straight-line values for the sales figures. To display all of the results of
the formula, it is entered into three cells in column C (C1:C3).
[image: Array formula that produces multiple results]
Array formula that produces multiple results
When you enter the formula =TREND(B1:B3,A1:A3) as an array formula, it
produces three separate results (22196, 17079, and 11962), based on the
three sales figures and the three months.
[image: Hide]Using array constants<javascript:ToggleDiv('divExpCollAsst_2')>
In an ordinary formula, you can enter a reference to a cell containing a
value, or the value itself, also called a constant (constant: A value that
is not calculated and, therefore, does not change. For example, the number
210, and the text "Quarterly Earnings" are constants. An expression, or a
value resulting from an expression, is not a
constant.)<javascript:AppendPopup(this,'ofConstant_1')>.
Similarly, in an array formula you can enter a reference to an array, or
enter the array of values contained within the cells, also called an array
constant. Array formulas accept constants in the same way that nonarray
formulas do, but you must enter the array constants in a certain format.
Array constants can contain numbers, text, logical values such as TRUE or
FALSE, or error values such as #N/A. Different types of values can be in the
same array constant— for example, {1,3,4;TRUE,FALSE,TRUE}. Numbers in array
constants can be in integer, decimal, or scientific format. Text must be
enclosed in double quotation marks— for example, "Tuesday".
Array constants cannot contain cell references, columns or rows of unequal
length, formulas, or the special characters $ (dollar sign), parentheses, or
% (percent sign).
The format of array constants
Array constants are enclosed in braces ( { } ).
Separate values in different columns with commas (,). For example, to
represent the values 10, 20, 30, and 40, enter {10,20,30,40}. This array
constant is known as a 1-by-4 array and is equivalent to a 1-row-by-4-column
reference.
Separate values in different rows with semicolons (;). For example, to
represent the values 10, 20, 30, and 40 in one row and 50, 60, 70, and 80 in
the row immediately below, you would enter a 2-by-4 array constant:
{10,20,30,40;50,60,70,80}.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/3/09, gyanesh jain <gyanjai...@gmail.com> wrote:
>
> Hi,
>
> How to use
>
>
> {=TABLE(,K11)}
>
>
> this type of function.
>
> --
> Thanks,
> Gyanesh Jain, BE, MBA (Finance)
> +91 98868 68488
> Please Save a tree...please don't print this e-mail unless you really need
> to
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
