Q1: I have two columns of data, need to do a repetitive comparison, after the comparison of the need to extract the non-duplicated data from a column, how to do?
If you want to compare whether column A and column B data is duplicated, there should be three kinds of results (that is, AB has, A has b none, B has a none), can be stored in column A has a B no data, in column D storage B has a no data, and then merge two columns of data, the method is as follows:
1. Enter the formula in the C1 cell:
=if (COUNTIF ($B: $B, A1) =0,a1, "")
Enter the formula in cell D1:
=if (COUNTIF ($A: $A, B1) =0,b1, "")
Copy the two formulas down to the corresponding row with the fill handle.
2. Sort by column C, set the column C data together, copy it to column A of another worksheet, sort by column D, and then set the column D data together and copy it to the end of column A of the other worksheet. (Note: These two actions are pasted with "paste/value")
3. Delete the CD two column from the original table and copy the data from column A in the other worksheet back to column C of the original table.
How to copy data that is not duplicated after Excel two column comparison to another column