CODEWITHSUNDEEP
excel
Vikram
Vikram

Reputation: 7515

Compare two columns on different excel files

I have two Excel files A and B. File A has a column Loan ID which are unique and File B has column loan ID which are repeatable and these loan IDs are from file A.

Now I need to identify any loan id which is not present in both the files. Do you have any trick for this?

Thanks Vikram

Upvotes: 1

Views: 2409

Answers (1)

Michael Eakins
Michael Eakins

Reputation: 4179

=IF(COUNTIF(B1:B5000B,A1)>0,"",A1)

The Final A1 represents the Column Loan ID value to return if the Value is not found in column B

Excel with two columns one the base column and one to find missing values in.

Upvotes: 1

Related Questions