ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can I delete both parts of a duplicate entry in excel (https://www.excelbanter.com/excel-discussion-misc-queries/105121-how-can-i-delete-both-parts-duplicate-entry-excel.html)

Chrisinct

how can I delete both parts of a duplicate entry in excel
 
I have two lists of numbers and I need to remove both of the duplicate
entries. I want to end up with a list that contains only the numbers that
have no duplicate. How can I do this?

Marcelo

how can I delete both parts of a duplicate entry in excel
 
hi, try the tips at:

http://www.cpearson.com/excel/duplicat.htm#Replacing
or
http://www.j-walk.com/ss/excel/usertips/tip073.htm


--

hth
regards from Brazil
May the force be with you
Marcelo
*******************


"Chrisinct" escreveu:

I have two lists of numbers and I need to remove both of the duplicate
entries. I want to end up with a list that contains only the numbers that
have no duplicate. How can I do this?



All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com