Duplicate Data

[yousufkhan]

I Have lot of duplicate data in excel colomn,I would like to mark up entires which appear more then One with numbers 1,2,3....The number should be put at the end of the word or the beginning,How to do Help me regarding this....

[TheExcelphile]

It won't be possible to put the number in the same cell as the word. It will have to be in a different cell.

Could you upload a sample with the required outcome, so that we may be able to help you better?
To upload a workbook, click on Go Advanced at the bottom of this thread, and click on the Manage Attachments button.

[haripopuri]

Are the duplicate values in continuous series or they can be anywhere in the column? If they can be anywhere, is it ok if we sort the column?
If the duplicate cells are one below another, it is easy to mark the way you want using VBA.

[TheExcelphile]

I've uploaded a sample with two combinations. You can use whichever you want, depending upon your needs.

If you want to read more about the formula I've used, go here.

Don't forget to click on the little star to the left of this post if you feel I helped!