Excel two columns of data comparison, find the first column difference second column of data (A-B)

Problems to be Solved:

Two columns of data, such as column A and column C, are used to find the data in column A that does not exist in Column C. For example, Xiao kangmin is the data in column A, but it does not exist in Column C, this is the result.

 

Figure 1

 

 

Method: Use the countif function.

1. in the new column, let column E be equal to the formula countif (C: C, A2). For example, if you drag this company to the entire column, column E will only show 1 or 0, 1 indicates that data in column A exists in Column C, and 0 indicates that data in column A exists in Column C.

 

 

2. f column, so that it is equal to If (E2 = 0, A2, ""), that is, when it is 0, it is the difference value. For example, see Figure 1 for the result.