I was asked to code on VBA to find duplicates in a column and paste them in other column.
NOTE: 1. If the value has been repeated more than twice, still you should paste the value into the other column only once.
2. Use of worksheets function is not allowed.

Please help me on this ..... thanks in advance.....