Now, let’s return to the function shown in Figure A, =UNIQUE(TableSales[Personnel]). In terms of structured referencing, that reference is short. But the reference =H3# is much shorter.

The PERCENTOF function has two arguments ... In my example, I've used a formatted Excel table and structured references. As a result, my formulas are easier to parse, and if I add more data ...

However, some people are less familiar with a special type of reference that comes with these tables: structured references.

The converse also proved true: Children in more structured activities displayed lower executive functioning abilities. “Executive function is extremely important for children,” Munakata told ...