Filters - Numbering Rows

  • Thread starter Thread starter twinkle17
  • Start date Start date
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
 
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
Excel Conditional Formatting 1
lookup and return column number 2
Looking for the value that indicates last row number that has filled cells 3
Calculation Time 2
Excel VBA 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Back
Top