structural table columns advantage

[lezawang]

Hi
I have a table like the one below. I inserted a table (Insert-->Table). Now I understand (thanks for you help). This table have these ranges

Table1[name]
Table1[store]
Table1[item]
Table1[price]

What is the benefit of using these ranges rather than I create my own ranges for example I select
D1:D10 and go to NameBox = PriceRange? Thank you.


[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]name[/TD]
[TD="width: 64"]store[/TD]
[TD="width: 64"]item[/TD]
[TD="width: 64"]price[/TD]
[/TR]
[TR]
[TD]linda[/TD]
[TD]east[/TD]
[TD]tv[/TD]
[TD="align: right"]662[/TD]
[/TR]
[TR]
[TD]jack[/TD]
[TD]east[/TD]
[TD]dryer[/TD]
[TD="align: right"]444[/TD]
[/TR]
[TR]
[TD]alex[/TD]
[TD]east[/TD]
[TD]computer[/TD]
[TD="align: right"]723[/TD]
[/TR]
[TR]
[TD]allen[/TD]
[TD]east[/TD]
[TD]tv[/TD]
[TD="align: right"]356[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD]east[/TD]
[TD]dryer[/TD]
[TD="align: right"]792[/TD]
[/TR]
[TR]
[TD]sam[/TD]
[TD]north[/TD]
[TD]washer[/TD]
[TD="align: right"]452[/TD]
[/TR]
[TR]
[TD]adam[/TD]
[TD]north[/TD]
[TD]tv[/TD]
[TD="align: right"]998[/TD]
[/TR]
</tbody>[/TABLE]

 

[tcardwell]

Table ranges are dynamic, your PriceRange range is not dynamic, if used in formula, formula will easily stop working.

 

[DRSteele]

One advantage of using structured references over your own named ranges is that you can select an entire range of data in TableColumn when constructing formulas by simply clicking the little black down-arrow that appears in the TableColumn's header. When the table expands or contracts, the formulas are dynamic.​