Numbering Duplicates with sequential numbers

[santhoshkunder]

Hi All,

Is this something which is possible in Excel,MS Access or SQL? i tried it in different ways using GROUP BY clause.I want to find out the Duplicates(Concatenating Sales Order and Item) with the sequential number.Column 'schedule' is what i am looking for. Pleas help me on this.

 

[Deepak]

It's not robust but simple.

 

[santhoshkunder]

It's not robust but simple.

Thanks a lot my dear friend. Not sure why did you say it is not robust.