Forum Discussion
Solved
Fnd unique Values
Hello, I have 19k rows in Col A and 30K rows in col B. The Col A matches the column B data.I want to remove the matching values and display the rest. I've tried true or false formula. it dosent hel...
=IF(ISNA(MATCH(B1,$A$1:$A$19000,0)),B1,"")You can try this formula in cell C1 and copy down as required.
=IF(ISNA(MATCH(B1,$A$1:$A$19000,0)),B1,"")You can try this formula in cell C1 and copy down as required.