finding misisng values

[satish_j]

I have 2 columns..say A & B(each having thousands of rows).They are basically identical columns but,total count of rows in each columns differ by some 20 rows.
Is there anyway i can find the rows that exists in columns A but not in column B?

 

[Trebor76]

Hi there,

Put this formula in a blank column (changing the ranges to suit)...

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$100,1,FALSE)),"No match","")

...and look out for rows flagged with "No match" or sort the range based on the column you used to insert the formula.

HTH

Robert

 

[satish_j]

Hi there,

Put this formula in a blank column (changing the ranges to suit)...

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$100,1,FALSE)),"No match","")

...and look out for rows flagged with "No match" or sort the range based on the column you used to insert the formula.

HTH

Robert

Thanks a lot..

 

[FishingIsMoreFun]

=IF(A2=B2,"match","No match")