Forum Discussion
creating a column from comparing two columns
I am trying to compare two columns of data and create a third column that contains the differences. I have been able to find a way but each column has over 400,000 entries and it is very time consum...
Hi,
Please populate column C with this formula:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"",B1)
This formula will show you the value if it's not in column A, otherwise, it will leave the cell blank.
Hope that helps
Haytham