Hello everybody, I need a little help to make the job done.
Ive got columns A and B, in column A Ive got 10000 cells and in B 200, but now i need to compare this two columns and delete duplicates in column A.
Ive figure it out how to highlight cells in column A which are identical with cells in column B. In conditional formatting I used formula =countif($B:$B,A1)=1, is there any addition to make highlighted cells to disappear?
Bookmarks