Read more

Read more

- Find missing data in 2 columns (Excel)
- Extract identical cells of 2 columns (excel) » Forum - Excel
- Checking data in 2 columns and sending email » Forum - Excel
- Matching similar data in 2 columns » Forum - Excel
- Excel - Compare columns to find missing data » How-To - Excel
- Excel - Display multiple columns in a validation list » How-To - Excel

This formula searches through the A column for the B1 value. If it doesn't find anything (COUNFIF is equal to 0) means the B1 is in B but missing in A. It will write the B1 value in the C1 cell. Otherwise it will leave the cell empty.

Copy this formula in the entire C column. You will probably have to replace ; with an ordinary comma but in Excel 2003 it works only with ;

You can do it the other way around in column D to see if some values from A are in A but not in B. =IF(COUNTIF(B:B;A1)=0;A1;"")

In column A, your number

In colunm B, their number

in column C

=IF(ISBLANK(A2)," ",VLOOKUP(A2,B$2:B$34,1,FALSE))

in column D

=IF(ISBLANK(B2)," ",VLOOKUP(B2,A$2:A$34,1,FALSE))

change the $34 to be how many rows you are comparing.

The isblank function is there to stop the comparison if the source cell is empty.

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.