Hi Experts,
hope all of you good, I have a file in which every cell have many duplicate entries, I want a formula which removes duplicate entries, I have attached a sample sheet where you can see column B which have actual data and Column C which have what I needed, I hope I got a solution for this issue.
Thanks in Advance.
Regards.
Aaru
Please try formula at D2
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(COUNTIF(B2,"*BLVD*"),SUBSTITUTE(B2,"BLVD","@",(LEN(B2)-LEN(SUBSTITUTE(B2,"BLVD",)))/4),B2),"BLVD",),TRIM(RIGHT(SUBSTITUTE(B2,"APT",REPT(" ",9)&"APT"),9)),)&" "&TRIM(RIGHT(SUBSTITUTE(B2,"APT",REPT(" ",9)&"APT"),9)),"@","BLVD"))
or cleaner with UDF =redup(B2)
Please Login or Register to view this content.
Thanks for the help, but it is not working for me, many duplicate entries remain the same
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks