Thanks for your help Teethless Mama,
and another small help required from you.
I observed that the formula is giving the number automatically.
now what i am looking is the formula should consider the number of entries
on a single date and for all them it should maintain the same (only one)
number. the number should change only when the date changed.
Hope I am clear in asking.
Thanks in advance.

"Teethless mama" wrote:

Try this:

=TEXT(COUNTIF($A$1:A1,A1),"000")

copy down as far as needed


"Vijay DSK" wrote:

Hi all,
Thanks for this forum for the help rendered in my previous issues.
Now stucked up with another one.
It is like ....
col1 col2
1
2
3
1
2
3
what i am looking is in column 2 a formula or function which gives as follows
col1 col2
1 001
2 001
3 001
1 002
2 002
1 003
Hope i am clear in asking the question