Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formula question
Someone sent me a workbook with a table of cells that all have the
following fomula in it: {=TABLE(,B23)} Table is not a named range and each cell returns a different value eventhough they all reference B23. B23 has a constant value in it. I know the {} mean it is an array but cant figure out what TABLE and (,B23) mean or do. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formula question
On Aug 13, 12:47*pm, Michael wrote:
Someone sent me a workbook with a table of cells that all have the following fomula in it: {=TABLE(,B23)} Table is not a named range and each cell returns a different value eventhough they all reference B23. B23 has a constant value in it. I know the {} mean it is an array but cant figure out what TABLE and (,B23) mean or do. Michael, You are looking at the formula for a data table. Search help for data table to see read about how data tables function. Best, Matthew Herbert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formula question
Here's a couple of videos. Maybe this will shed some light on the subject:
http://www.youtube.com/watch?v=I7iI0hxAtwo http://www.youtube.com/watch?v=qWLHJ4dDUoo HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Matthew Herbert" wrote: On Aug 13, 12:47 pm, Michael wrote: Someone sent me a workbook with a table of cells that all have the following fomula in it: {=TABLE(,B23)} Table is not a named range and each cell returns a different value eventhough they all reference B23. B23 has a constant value in it. I know the {} mean it is an array but cant figure out what TABLE and (,B23) mean or do. Michael, You are looking at the formula for a data table. Search help for data table to see read about how data tables function. Best, Matthew Herbert |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formula question
Does not seem to be a defined table. TABLE does not show up in defined
names as it does when I define one of my own. Also doesnt look like structured reference syntax-- such as =SUM(Table1[[#Data],[amount]]) -- which uses brackets. I cant access you tube at work but will check those videos out at home this weekend. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formula question
On Aug 14, 6:24*am, Michael wrote:
Does not seem to be a defined table. TABLE does not show up in defined names as it does when I define one of my own. Also doesnt look like structured reference syntax-- such as =SUM(Table1[[#Data],[amount]]) -- which uses brackets. I cant access you tube at work but will check those videos out at home this weekend. Michael, You can access the help files on your local computer, so take a look at "data table" in the help documentation. At least the help documentation will give you some information before you can access YouTube. Also, do a simple internet search on "data tables" (or some derivative of excel data tables). There is a lot of data out there which you will likely be able to view without your firewall blocking the website. And no, TABLE is not a defined name because it is an array function. Best, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array formula question | Excel Programming | |||
Array Formula Question | Excel Worksheet Functions | |||
Array Formula question | Excel Programming | |||
SUM array formula question | Excel Worksheet Functions | |||
Array Formula Question | Excel Programming |