Structured references are also used within formulas outside an Excel table that reference table data. In this example, I will use the XLOOKUP formula to generate a weekly profit in cell E4 based ...

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 Problem with Excel Tables Excel tables handle structured references inconsistently, which can create confusion and errors during formula manipulation. For example: When you use `Ctrl+C` and ...

By using a simple formula and specifying the time intervals in the TIME () function, you can quickly create a series of incremental time values. AutoFill is even quicker.