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.
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.
Dear William,
I use one easy way to solve this task you may also try it. What ever the size of the database you do the following
#1 Sort your database by the coloumn where your duplicate data will be
#2 Then use excle exact comand to find duplication. Results come as true or false where true stands for duplicat.
#3 You may do conditional formating True as red colour
#4 Then filter all True values and Copy, Paste to another location
See the attachment Duplicate Ent for more detail
Hope this will help you
Regards,
Prabir Biswas
Dear Prabir,
Thank you Prabir, it worked for me. May I know is there any way to delete all the value that we get as duplicate?
Regards
Williams
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.Originally Posted by Williams
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks