Sumit Bansal's Trump Excel

Free Online Excel Training and Tutorials

  • Rated1.8/ 5
  • Updated 5 Years Ago

How to Filter Cells that have Duplicate Text Strings (Words) in it

Updated 5 Years Ago

How To Filter Cells That Have Duplicate Text Strings (Words) In It
In this tutorial, I will show you how to create a custom function using VBA to identify duplicate text strings in a sentence. Here I take an example of addresses, where the city or area name has been repeated by mistake. The VAB custom function quickly gives you TRUE if there are duplicates and FALSE if not.
Read More