Serial No.
 

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

Serial No.
 

Hi,

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

Mike

"Aju" wrote:

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

Serial No.
 

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

"Mike H" wrote:

Hi,

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

Mike

"Aju" wrote:

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

Serial No.
 

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

On Mar 31, 2:04*pm, Aju wrote:
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



"Mike H" wrote:
Hi,

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

Mike

"Aju" wrote:

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- Hide quoted text -

- Show quoted text -

Serial No.
 

Thanks alot dear

Aju

"Pete_UK" wrote:

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

On Mar 31, 2:04 pm, Aju wrote:
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



"Mike H" wrote:
Hi,

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

Mike

"Aju" wrote:

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- Hide quoted text -

- Show quoted text -

Serial No.
 

You're welcome.

Pete

On Mar 31, 2:17*pm, Aju wrote:
Thanks alot dear

Aju



"Pete_UK" wrote:
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

On Mar 31, 2:04 pm, Aju wrote:
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

"Mike H" wrote:
Hi,

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

Mike

"Aju" wrote:

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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -