I have a list of URLS and emails in columns D and E. I don't want to use the excel find duplicates as it deletes all duplicates, where as I want them moved to another sheet.
Also if there are similarities then I want it to highlight the text in Orange.
See below
From this
<tbody>
Emails...
I've been researching for a formula to give me a score of similarities between cell a2 and b2? There are no exact matches in my data, case sensitivity is not an issue.
I see many macros/VBA but I don't have any experience in using these.
Is it possible to create the 'Levenshtein distance'...
Hi Guys,
I tried this last week but no luck.
I'm going to try a better explanation.
I have two category columns and one value column.
Category column A will always be filled. But category B will only be filled for one of the cells. I want Column B to be full of whatever value is...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.