Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sequence numbers
how i can put sequence number after applying filter.
if anyone can help me on this matter, i'll be very thankful. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sequence numbers | Excel Discussion (Misc queries) | |||
Finding numbers missing from a sequence | Excel Discussion (Misc queries) | |||
Repeating a sequence of numbers down a column | Excel Discussion (Misc queries) | |||
how do I sequence numbers | Excel Discussion (Misc queries) | |||
Inventory numbers - Consecutive, but out of sequence | Excel Discussion (Misc queries) |