Microsoft Office Tutorials and References
In Depth Information
AUTO-NUMBER RECORDS AND COLUMNS IN AN EXCEL DATABASE
Because CELL("width",F1)>0 , this evaluates to MAX($A2:E2)+1 , which
is Max(1,2,3,0,0)+1 = 4 .
Gotcha: Although the record numbering auto-updates with changes in AutoFilter
settings, the column header numbering does not update as you hide/show
columns. You need to force a recalculation by pressing F9 in order for these
formulas to update.
Summary: You can build formulas to automatically number records and column
headers in a database to which AutoFilter is applied and in which selected
columns are hidden.