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.

name	store	item	price
linda	east	tv	662
jack	east	dryer	444
alex	east	computer	723
allen	east	tv	356
mary	east	dryer	792
sam	north	washer	452
adam	north	tv	998

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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.​