HI guys,
i got 2 columns A and B with big data (each ca. 50 000, many different entries, many same). I tried so many things now "conditional formatting" colouring the doubles red, which works great, but it is so much data my excel freezes when trying to sort them so I can delete them.
Has someone got a macro for comparing 2 columns, deleting them directly in its original column? (dont want extracted data in column C or sth, cause I must know where it was before - A or B).
I also tried PowerQuery but can't learn to use it, maybe it is easier than I think? Can't also believe that I cant find a macro for this. Seems to me like a standard procedere?!
Bookmarks