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?
 
Top