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. |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com