How to merge two list
How do you merge two .xls list that are the same and then remove doubles.
Thnks in advance.
Jose
Jose,
Do you plan to do this work in Numbers or Excel?
Jerry
4 replies
They send me excell and I save it to numbers. Same cells and tables every month.
Thanks
Would like to merge into one master each month to send to the mailing house.
Thanks
Jose,
If you open both Excel documents and, in turn, copy the list and paste into a Numbers document you can detect the duplicates by sorting the list so that identical entries lie next to each other. Then you can search out the duplicate visually, or you can use an expression to help find them.
If your list is in column A of a table named Data, with the first data in row 2, you can enter this expression in another column:
=IF(COUNTIF(OFFSET($A$1, 0, 0, ROW()-1), A)=0, "", "Dup")
Sort on the column with the expression and then select all the rows containing "Dup" and delete them.
Jerry
How to merge two list