array formula question

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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.
 
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.
Click to expand...

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
 
Here's a couple of videos. Maybe this will shed some light on the subject:

HTH,
Ryan---
 
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.
 
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.
Click to expand...

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
 
Back
Top