Duplication

Originally Posted by Williams

How can I find the duplicate entries and paste it into another column? The data base is large; is there any formula that I can directly take all the duplicate entries to anothr column.

you can try using an IF statement. I have a spreadsheet that I work from every day that lists account numbers, I have to eliminate all of the duplicate account numbers from that spreadsheet.

I create a new column to the left of my account numbers, Sort by the column that has the account numbers (in this case, B), start all the way at the end of my data range, type =IF(B3<>B2,1,"dup") and then paste the formula all the way up to the top.

All of the duplicate entries will present with "DUP" in column A. You can then highlight column A, copy>paste special>values

last but not least, apply an auto filter to your data and filter out all of the "DUP" cells, copy them and paste them wherever you need to.

this seems like a pretty convaluted solution, but it works for me!

I have attached an example of my steps.

I hope it helps, I just thought you might like another option.

good luck,

Laura