how i can put sequence number after applying filter.
if anyone can help me on this matter, i'll be very thankful.
how i can put sequence number after applying filter.
if anyone can help me on this matter, i'll be very thankful.
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?
--
Regards,
Ron
"Ashley" wrote:
> how i can put sequence number after applying filter.
> if anyone can help me on this matter, i'll be very thankful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks