SOLVED

Fnd unique Values

Occasional Visitor

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 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.

 

=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

 

 

best response confirmed by sumanth0193 (Occasional Visitor)
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.

remove matching entries.JPG