Forum Discussion
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 help. is there a way can any please help.
Thanks in Advance
=IF(ISNA(MATCH(B1,$A$1:$A$19000,0)),B1,"")You can try this formula in cell C1 and copy down as required.
2 Replies
=IF(ISNA(MATCH(B1,$A$1:$A$19000,0)),B1,"")You can try this formula in cell C1 and copy down as required.
Hi sumanth0193
You would use vlookup function to search for the values and write it in C1then fill it until the last record of column b.
=VLOOKUP(B1,$A$1:$A$19000,1,0)
The forumla will returen the number in C if the number in cell B is available in Column A, if not available will return #N/A, then you can sort the table according to column C then delete all the rows except the once with #N/A
