Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array / Function HELP!!!
What does the following array function accomplish? How does it work?
{=TABLE(,B13)} I've searched the groups and the MS website but can't find anything. Any help is greatly appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array / Function HELP!!!
H Chris,
These are the functions that are employeed by Excel when you make a Data, Table. You can't enter them manually. {=TABLE(,B13)} The means that this is a one variable data table, with the layout of the changing variable values in a column and the one being used by the default formula being located in cell B13. You can get a little info on this by typing Data Table into the help system. To the best of my knowledge, people tend not to use this feature, for one thing you can duplicate its functionality with more explicit formulas or with a pivot table. -- Cheers, Shane Devenshire Microsoft Excel MVP "chris" wrote: What does the following array function accomplish? How does it work? {=TABLE(,B13)} I've searched the groups and the MS website but can't find anything. Any help is greatly appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array / Function HELP!!!
Perfect, thank you!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OR function in array-entered IF function | Excel Worksheet Functions | |||
How To Do This Array Function | Excel Worksheet Functions | |||
Is there an array function or something like it? | Excel Worksheet Functions | |||
need some help with an array function | Excel Discussion (Misc queries) | |||
#DIV/0! in the array function | Excel Worksheet Functions |