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