This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Is there an easy way to put two columns on a page that should both have the same information and figure out what value is missing that is in one column that is not in the other column. The value could be missing from either column.

=A1=B1

if equal it will TRUE

if it not equal then it wil return FALSE

once the formula is defined , drag on the entire column.

Put this formula in Column C

=IF(A48=B48,"MATCH","DIFFE

So then you would see the Word "Match" in C if they were the same.

Obviously, or maybe not, this formula if for row 48, Change it to your row number and then copy the cell to other cells in column C and it will change the row number for you.

=A1=B1

if equal it will TRUE

if it not equal then it wil return FALSE

once the formula is defined , drag on the entire column.

=VLOOKUP(A1,$B$1:$B$3,1,FA

This says "try to find the value that's in cell A1 somewhere in the range B1 to B3, and return the value in column B (the "first" column in our one-column range) but only if it's an exact match (range lookup = "false").

Column D: =COUNTIF($B:$B,$A1) copy down for the extent of values in column A

Column E: =COUNTIF($A:$A,$B1) copy down for the extent of values in column B

This will count the occurrences of each entry in the other column. The results which are zero shows that value does not occur in the other column.

If you apply an AutoFilter to columns D & E you can then filter on each column separately to show only those values where the result is zero. You will then be able to copy the values from column A or B and the copy will only take the values that are visible.

Thanks

Rob

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

List1 List2

A H

B G

C F

D D

E N

F A

G B

H X

Select first column, and add conditional formatting for it (use formula):

=COUNTIF($B$2:$B$

9, $A2)=0Select fill color for missing values

Correct max row to real

Same for second column:

=COUNTIF($A$2:$A$9, $B2)=0

Compare-lists.xlsx