Thanks:  0
Likes:  0

# Thread: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

2
3
4
5

2. ## Re: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

Would a VBA solution be acceptable?

3. ## Re: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

Formula for SNO, =(SUBTOTAL(3,B\$1:B2)-1)

4. ## Re: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

Assuming that the SNO numbers start in A2 then possibly

=SUBTOTAL(103,B\$2:B2)

5. ## Re: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

Originally Posted by MARK858
Assuming that the SNO numbers start in A2 then possibly

Thank you so much . It worked. Sorry for the delayed reply as I was not well.

Best Regds,

Titus

6. ## Re: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

Originally Posted by Ruddles
Would a VBA solution be acceptable?
Not familiar with VBA. Solution provided by MARK858 . Thank you......

7. ## Re: Renumbering of filtered data ( Pls see I need the s.no to be 123 automatically after filter is done.

Originally Posted by Titus sabu
Thank you so much . It worked. Sorry for the delayed reply as I was not well.

Best Regds,

Titus
You're welcome