Serial No.

A

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
 
M

Mike H

Hi,

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

Mike
 
A

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
 
P

Pete_UK

Try this in row 2 of a helper column:

=SUBTOTAL(3,D$1:D2)-1

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

Hope this helps.

Pete
 
A

Aju

Thanks alot dear

Aju

Pete_UK said:
Try this in row 2 of a helper column:

=SUBTOTAL(3,D$1:D2)-1

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

Hope this helps.

Pete
Click to expand...
 
Top