Hi,
I have a long list of uncleaned data of account names with similar names. See below example. 1st col below shows that there are 5 accounts, but after manual adjustment line by line, there are only two accounts namely ABC and Foser. Is there anyway to use formula to remove duplicates...