Fnd unique Values

[sumanth0193]

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

[#2]

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

[#3 · Accepted solution]

@sumanth0193 

=IF(ISNA(MATCH(B1,$A$1:$A$19000,0)),B1,"")

You can try this formula in cell C1 and copy down as required.