View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vijay DSK[_2_] Vijay DSK[_2_] is offline
external usenet poster
 
Posts: 33
Default Count and Add 1 to the count value

A speedy advice will greatly appreciated from Teethless Mama or any one

"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