Hi,

I need help for the below mentioned query.

For the below mentioned vales in Column A, I want the display values as in Column B, i.e if a value is duplicated a number series should follow

Column A Column B
28537Ref 1
28538Ref 1
28539Ref 1
28537Ref 2
28539Ref 2

Kindl help.....