SOLVED

# Fnd unique Values

Copper Contributor

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

2 Replies

# Re: Fnd unique Values

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 (Copper Contributor)
Solution

# Re: Fnd unique Values

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

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

1 best response

Accepted Solutions
best response confirmed by sumanth0193 (Copper Contributor)
Solution

# Re: Fnd unique Values

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

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