Galapagos15
Board Regular
Is there a way to get the similarity percentage between text in two cells that are in the same row? I've tried Fuzzy Lookup but it doesn't compare the cells in the same row which is what I need. I know my last option is PWRSimilarity but I wanted to research free options first. Thanks in advance!
Example:
Column____________A_____________________B_________________________Need Similarity %?
Row#
1______________ABC Company___________ABC Co_______________________________? %
2______________John H. Smith___________John Harry Smith_______________________? %
3______________M. Jack Cole_____________Matt J. Cole___________________________? %
4______________Harry Adam Jacks_________H. J. Jacks____________________________? %
5______________IBI Company_____________Integrated Business Incorporated__________? %
Example:
Column____________A_____________________B_________________________Need Similarity %?
Row#
1______________ABC Company___________ABC Co_______________________________? %
2______________John H. Smith___________John Harry Smith_______________________? %
3______________M. Jack Cole_____________Matt J. Cole___________________________? %
4______________Harry Adam Jacks_________H. J. Jacks____________________________? %
5______________IBI Company_____________Integrated Business Incorporated__________? %
Office Powerups
- Excel: How to Best Import External Data into Excel & Import data from the Web to Excel - Duration: 11:16. Leila Gharani Recommended for you.
- PwrSIMILARITY - Office PowerUps (never tried it though) Oh sorry you know about it already (and presumably the 30 day free trial which may not be long enough for you).
Office Powerups
SideKick 365 CRM is a complete CRM solution that installs into SharePoint running in Office 365. It is the first solution that leverages SharePoint and the Power Platform of PowerApps, PowerBI, and Microsoft Flow to deliver amazing functionality at a fraction of the competitions price. Build powerful end-to-end business solutions by connecting Power Apps across the entire Microsoft Power Platform—and to Office 365, Dynamics 365, Azure, and hundreds of other apps—to drive innovation across your entire organization. CNET Download provides free downloads for Windows, Mac, iOS and Android devices across all categories of software and apps, including security, utilities, games, video and browsers.