How to remove lines if the value is in another column

[rlupe]

Basically the title.

If values 16451 and 18888 are in both columns Find and Replace, how would I keep them in the Replace and delete the line where it is in Find?

[FrederikE · Accepted solution]

Hey @rlupe,

That is not the purpose of the F&R tool. Instead, you can use a Join Tool for this.

Join the column with the values you want to keep and take the Inner Join output

OR

Join on the column with the information you don't want to keep. And then take the Left/Right output of the join.

[rlupe]

right, this is a step I'm taking before the find and replace. But you gave me an idea with the join that worked, so thanks!