Filters - Numbering Rows

T

twinkle17

I want to number the rows of filtered cells, 1, 2, 3...

I can't fill series, or use the formula =a2+1...

Is there any way I can do this?

Cheers
 
T

T. Valko

Try somehting like this:

Put the row count outside of the filtered data. Assume the filtered range is
B2:C10.

Enter this formula in A2 and copy down to A10:

=SUBTOTAL(3,B$2:B2)

I'm assuming there are no empty cells in B2:B10.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Sequential Numbering 2
automatically numbering rows 2
adding rows into the table 1
Count Number of Visible Rows in Filtered View 2
Row Numbering 6
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
numbering rows, but skipping blanks 13

Top