sequence numbers

A

Ashley

how i can put sequence number after applying filter.
if anyone can help me on this matter, i'll be very thankful.
 
R

Ron Coderre

If your list begins in cell A1....

Insert a column and put SEQ in the "new" cell A1.
Then put this formula in Cell A2 and copy down:
=SUBTOTAL(3,B$2:B2)

Now filter your list. That formula will count the number of non-blank,
visible cells.

Note the dollar sign in the formula. Cell A3 will count the non-blank,
visible cells from A2:A3. Cell A5 will count them from A2:A5, etc.

Does that help?
 

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

Help with an Excel macro please? 6
how can i change a sequence of numbers using find replace 2
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
re-numbering or sequence priorities formula 2
Duplicate Mail Merge Record Every Time 5
How to? Please help! 0
Show number sequence breaks? 5
Display Missing invoice numbers from a sequence. 2

Top