Sorry for my poor English but if you would see the data I attached, there is two columns which in the "column A" you can see that the numbers are random.
Number 1 to 378 is filled in the "column B".
What I would like to do is to delete the numbers (colored in red) in "column B" which are duplicated in "column A" . Of course I can delete them one by one, but I would like to know a faster way to delete ONLY the same numbers from "column A".
I did try with "Data Tools > Remove Duplicates" but nothing actually changes even when a message pops up which says deletion was complete.
Than you
Bookmarks