Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase serial number
I have to maintain our representative database & send it to our head office
lilke A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312 continued to end of data. Now I have to keep month-wise record according to Rep ID. Now I want auto increase serial no. in respect of Rep. ID i.e 1) Sl No. will be continue if Rep. Id is same. example as below - A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312 is it possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase serial number
On Jan 4, 10:17 pm, Montu wrote:
I have to maintain our representative database & send it to our head office lilke A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312 continued to end of data. Now I have to keep month-wise record according to Rep ID. Now I want auto increase serial no. in respect of Rep. ID i.e 1) Sl No. will be continue if Rep. Id is same. example as below - A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312 is it possible. In A2... =COUNTIF(E$2:E2,E2) filled down to bottom-most row with data. Ken Johnson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase serial number
On Jan 4, 10:17 pm, Montu wrote:
I have to maintain our representative database & send it to our head office lilke A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312 continued to end of data. Now I have to keep month-wise record according to Rep ID. Now I want auto increase serial no. in respect of Rep. ID i.e 1) Sl No. will be continue if Rep. Id is same. example as below - A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312 is it possible. =COUNTIF(E$2:E2,E2) in A2 then filled down to bottom-most row with data. Ken Johnson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase serial number
Thank you, it's working good, wish you Happy New Year
"Ken Johnson" wrote: On Jan 4, 10:17 pm, Montu wrote: I have to maintain our representative database & send it to our head office lilke A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312 continued to end of data. Now I have to keep month-wise record according to Rep ID. Now I want auto increase serial no. in respect of Rep. ID i.e 1) Sl No. will be continue if Rep. Id is same. example as below - A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312 is it possible. =COUNTIF(E$2:E2,E2) in A2 then filled down to bottom-most row with data. Ken Johnson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
increase serial number
On Jan 5, 4:11 pm, Montu wrote:
Thank you, it's working good, wish you Happy New Year "Ken Johnson" wrote: On Jan 4, 10:17 pm, Montu wrote: I have to maintain our representative database & send it to our head office lilke A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 2 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 3 13/11/2007 HTYVD7475K S.N.Bose 0312 continued to end of data. Now I have to keep month-wise record according to Rep ID. Now I want auto increase serial no. in respect of Rep. ID i.e 1) Sl No. will be continue if Rep. Id is same. example as below - A B C D E 1 Sl No. Recp. Dt PAN No. Applicant Name Rep. Id 2. 1 11/11/2007 ABCDE1234F A.K.Barman 0312 3. 1 12/11/2007 GHJBN5826L U.K.Ghosh 0256 4. 2 13/11/2007 HTYVD7475K S.N.Bose 0312 is it possible. =COUNTIF(E$2:E2,E2) in A2 then filled down to bottom-most row with data. Ken Johnson Happy New Year! Thanks for the feedback. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time serial number | Excel Discussion (Misc queries) | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
Formula for serial number | Excel Discussion (Misc queries) | |||
serial number decode | Excel Worksheet Functions | |||
generate serial number | Excel Worksheet Functions |