To understand how this formula works, you need to know how the INDEX() and COUNTA() functions work: The formula uses the structured references to the Table and the Invoice Date column: =INDEX(Invoices,COUNTA(Invoices)) Figure A This formula returns the last date in column C. As you can see, the formula and the Table accommodate the Table's Total Row and adjacent data. In addition, structured references are easier to read than cell references they're similar to range names in this respect.įigure A shows a simple Table of invoice data and a formula (E2) that returns the last date in column C, Invoice Date. That means you can position the formula almost anywhere and you can enter data above and below the column in question. The formula uses structural references, so it's long, but the formula references only the Table. Thanks to Excel's Table object, this sort of task is simpler than it used to be. SEE: Build your Excel skills with these 10 power tips (TechRepublic PDF) Use a Table The browser edition doesn't recognize the Table object, but the formula still works-Excel is smart enough to use the Table object's structural references if you open the file in the browser. The data set formula won't work in the earlier menu versions, and macros don't work in the browser edition. For your convenience, you can download the demonstration.
I'm using Excel 2016 on a Windows 10 64-bit system.
Excel is still a security headache after 30 years because of this one feature.How to see who is trying to break into your Office 365 and what they're trying to hack.Microsoft reveals pricing and other details for Office 2021.
0 kommentar(er)
