increase serial number

M

Montu

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.
 
K

Ken Johnson

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.
Click to expand...

In A2...

=COUNTIF(E$2:E2,E2)

filled down to bottom-most row with data.

Ken Johnson
 
K

Ken Johnson

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.
Click to expand...

=COUNTIF(E$2:E2,E2) in A2 then filled down to bottom-most row with
data.

Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use formula to copy database to another 0
Tranform Pivot Query? 3
counting the number of consecutive days 12-17-09 2
get a list of sequence number that meet 3 criteria 0
Serial Number - Temporarily In A Query 7
Combining records by date 1
Filter for Day of the Week (part 2) 0
Number of hrs worked in a week, based on dates in a different column 1

Top