Visible Rows, Dynamic Row Numbering, Conditional Formatting, and Formulas

[Jeffrey Mahoney]

Jeffrey Mahoney submitted a new Excel article:

Visible Rows, Dynamic Row Numbering, Conditional Formatting, and Formulas - Use Visible Rows for dynamic row numbers, conditional formatting every other row.

Using Subtotal on every row of your range table, you can display sequential row numbers for visible rows only. With that you can also fill every other row with a cell color just like a defined Excel Table even when rows are filtered. You can also use ****IFS functions to get results for visible rows only.

Dynamic Row Numbering
The Key to the whole thing is the formula in cell A3. It shows a row number only if the row is visible (not filtered out)...

Read more about this Excel article...