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