Table

[joe4635]

I see this reference in a cell: {=TABLE(,B26)}. I know that the braces represent array formulas but TABLE is not a valid function. Does anyone know what this means? Your help would be appreciated. Joe

 

[DRSteele]

Welcome to the forum.

The curly braces will surround the entry in a cell when the formula is entered as an Array (with Ctrl+Shft+Enter) or when there as been a Data Table created (which can be found on the ribbon under Data | Forecast | What-if analysis | Data Table). When the Data Table has been created, cells involved cannot be edited piecemeal.

Check out this and other videos on youtube in the ExcelIsFun channel and Bill Jelen's channel to discover a bit about how Data Tables work. https://www.youtube.com/user/ExcelIsFun/search?query=data+table https://www.youtube.com/watch?v=fsWypGw5lGw

 

[Amanda Wilso]

In addition, the data table formulas are a series of =TABLE() functions - this function is just for show. You can't use it in any other context.

For more infotmations check the link :
https://support.office.com/en-us/ar...ta-table-e95e2487-6ca6-4413-ad12-77542a5ea50b

 

[joe4635]

Welcome to the forum.

The curly braces will surround the entry in a cell when the formula is entered as an Array (with Ctrl+Shft+Enter) or when there as been a Data Table created (which can be found on the ribbon under Data | Forecast | What-if analysis | Data Table). When the Data Table has been created, cells involved cannot be edited piecemeal.

Check out this and other videos on youtube in the ExcelIsFun channel and Bill Jelen's channel to discover a bit about how Data Tables work. https://www.youtube.com/user/ExcelIsFun/search?query=data+table https://www.youtube.com/watch?v=fsWypGw5lGw

Thanks for the answer. And quick as well. Much appreciated!

 

[Zack Barresse]

I would be remiss if I didn't mention this blog post by Dr Liam himself on the matter (quite the subject matter expert - as far as I know, the best in the world):

https://www.sumproduct.com/thought/data-tables

 

[DRSteele]

Super! Thanks, Zack. I added it to my list of websites to regularly consult.