Excel column comparision.

Closed

patilashish Posts 2 Registration date Wednesday December 9, 2015 Status Member Last seen December 9, 2015 - Dec 9, 2015 at 07:00 AM

Hey, I want to compare two tabs in separate columns with data which gives a match (Its okay if not exact) even though the words are jumbled or same. So, is there any formula to do this task? Eg:In Column A1 it is "PONDS WHITE BEAUTY FACIAL FOAM 50 g TUB" & column B1 has "Pond's Facial Foam - White Beauty, 50g Tube".

Excel column comparision.
Excel date format dd.mm.yyyy - Guide
Transfer data from one excel worksheet to another automatically - Guide
Number to words in excel - Guide
Screenshot in excel - Guide
Kernel for excel - Download - Backup and recovery

Similar discussions

VBA find column by name and sort

How to calculate positions (1st,2nd,3rd...) in Excel

Excel - To generate unique ID

Similar discussions

Subscribe To Our Newsletter!