Filter data in column A and column B in Excel. filter data in excel.

Filter data in column A and column B in Excel. filter data in excel.

Operation Manual

Note:

Column A represents Column B in February as February.

 

1. List data that appears in January

= IF (COUNTIF (A: A, B1), B1, "NONE") to check whether the data in column B has appeared in column A. IF it appears, we use B1 to indicate it, "None" indicates none. In fact, column B (December) appears in column A (December.

 

 

2. List the separate data for January. Here we will remove the data for January and January.

= IF (COUNTIF (B: B, A1), "", A1)

 

3. List the separate data for January. Here, we will remove the data shared between January and January.

= IF (COUNTIF (A: A, B1), "", B1)

 

 

4. The data listed in the above operation has blank cells ..

Select "paste selected" for the required data to be pasted"

 

 

Select "value" in the pop-up box and click "OK.

 

 

See how to remove Spaces