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.

On Aug 13, 12:47*pm, Michael <mfg...@gmail.com> 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

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 <mfg...@gmail.com> 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
>

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.

On Aug 14, 6:24*am, Michael <mfg...@gmail.com> 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