Serial No.

[Aju]

Anyone know how to do the Sl.No. in excel?
The condition is if you filter any row, the Sl.No should be changed
automatically.
With Regards,
Aju

 

[Mike H]

Hi,

I'm a bit confused by what you mean by SL.No, please explain and someone
will help.

Mike

 

[Aju]

It means Serial Number.
For example, The serial number is 1,2,3,4,5,6,7,8,9,10....
If we filter some heading its coming 1,3,7 something like that
It should come 1,2,3 with filter
Regards
Aju

 

[Pete_UK]

Try this in row 2 of a helper column:

=SUBTOTAL(3,D$12)-1

where column D contains contiguous data and a heading in row1. Copy
down to suit.

Hope this helps.

Pete

 

[Aju]

Thanks alot dear

Aju

Try this in row 2 of a helper column:

=SUBTOTAL(3,D$12)-1

where column D contains contiguous data and a heading in row1. Copy
down to suit.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete

Thanks alot dear

Aju






- Show quoted text -