Hello,
I have a sheet with customer ID and addresses, but many users over time have entered addresses in many ways... For example, some will enter "St." and some will enter "Street". I would like to automate this manual process of auditing these inconsistencies. Is there any way that anyone knows to write a formula or conditional formatting that would help point these out? I have attached a sheet as a reference. Thanks!!
What's the goal here. Is it simply to remove any duplicates for a particular Customer Ref.
If so why not use say the =LEN() function to identify the longest name since that's likely to be the preferred choice.
In C2 copied down
Formula:
Please Login or Register to view this content.
Then sort A:C by column A ascending and column C descending.
Then in D2 copied down:
Formula:Please Login or Register to view this content.
Finally filter A:D for values >1 in column D, then select then filtered rows and delete them.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks