| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| form serial number | Excel Discussion (Misc queries) | |||
| Dates as Serial Values | Excel Discussion (Misc queries) | |||
| serial number decode | Excel Worksheet Functions | |||
| Serial Dates | Excel Discussion (Misc queries) | |||
| Serial Number List | Excel Discussion (Misc queries) | |||
Linear Mode
