Ways to compare the similarities and differences of Excel two column data

Ways to compare the similarities and differences of Excel two column data

This example uses advanced filtering methods that compare the similarities and differences of Excel two column data. Special reminders, with advanced filtering, requires two comparisons of the same data column headings.

1, the mouse placed in a column any content cells, data, advanced, way by default first, the list area automatically captured as a column of the data range, the condition area with the mouse box to select the data Region D column.

2, in the B-column callout, select column B those filtered blank area, input 1,ctrl+enter.

3, data, sorting and filtering, clearing.

4, the mouse to place any one of the data cells, data, advanced, way by default first, the list area automatically capture for D column with the data area, the condition area to manually select a column of the data range, determine.

5, in the e column for labeling, select the filtered e-column corresponding to the blank area, input 1,ctrl+enter.

6. Set the conditional format for columns A and D, highlighting the data that are not in the other column.

Select the A2:a21 range for column A, start, style, conditional formatting, new rule, rule type-use formula, = $B 2 = "", fill in red in format

Select the D2:d16 cell range in column D, start, style, conditional formatting, new rule, rule type-use formula, = $E 2 = "", fill in red in format