Fnd unique Values

Occasional Visitor


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 Replies

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.




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



best response confirmed by sumanth0193 (Occasional Visitor)



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

remove matching entries.JPG