News
6mon
HowToGeek on MSNEverything You Need to Know About Structured References in ExcelHowever, some people are less familiar with a special type of reference that comes with these tables: structured references.
Using the IF function with absolute references forces the cell reference inside a formula to remain constant. Open an Excel worksheet and add data to two columns, where the first column has one ...
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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results