formulate sequential numering in an auto-filtered column

  • Thread starter Thread starter alienscript
  • Start date Start date
A

alienscript

Hi,

I have a data worksheet where I auto-filtered the columns.
Example, in a blank auto-filtered column G, I would like to have
auto-numering starting from 1 until the last auto-filtered row.

What formula to use ?

Thanks in advance for help.
 
You can use a formula to calculate the row number. For example, in
cell Gw, enter the following formula:
=SUBTOTAL(3,$A$2:A2)

where column A contains no blank cells.
Copy down to the last row of data.

Note: Don't use this formula in conjunction with the Data>Subtotal
feature. When you choose to Remove Subtotals, it deletes the lines that
contain a Subtotal formula.
 
Back
Top