Hello, there are duplicated numbers in column A (I defined duplicates by using conditional formatting), in front of each number in column B, I put "x" to define the current revision of document number. When I put a new number in column A which can be also duplicated I must put in front of that number "x". And delete previous "x"es. I do deletion one by one, which is time consuming. OK, is there any formula to delete previous "x"es of duplicated numbers?
Solved by I. U. in 14 mins