The ways to deal with different case when correcting typos in ExcelIn one of my posts I wrote about the Fuzzy Duplicate Finder add-in by Ablebits. As I promised, this time you will read about its new feature "Keep case of the same values in the node" and see how a small option can be of big help... Continue reading
Video: Search and correct typos in Excel with Fuzzy Duplicate FinderHave you ever wondered how many typos a large table can contain? Now you can check this, as well as correct all misprints in minutes. Fuzzy Duplicate Finder is specially designed to help you find typos in large amounts of data. It offers a number of useful options to make the searching and correcting even easier... Continue reading
The easiest way to delete duplicates from your Excel tablesNo matter if you have been using Duplicate Remover add-in for a long time or have never heard of it, you'll see something new as the new version is out. If you want to compare two tables and find dupes, see how to do it using Duplicate Remover. Those of you who know and use the add-in will see what's new in the latest version of it Continue reading
Fuzzy Duplicate Finder for Excel: what’s new?Have you ever been overwhelmed by the number of misprints you need to correct in your Excel tables? This post looks at using the new features of Fuzzy Duplicate Finder add-in as an easy way of finding fuzzy duplicates and correcting typos in a couple of clicks... Continue reading
How to find duplicates and unique values in Excel with Conditional FormattingYou created an Excel spreadsheet one day, updated it the next week, maybe someone else added a bit more information and it snowballs from there? Or maybe your problem is just the opposite, finding that one unique value in the ever growing spreadsheet; Conditional Formatting solves both of your problems... Continue reading
Find duplicates in ExcelFinding duplicates in Excel can be a tricky endeavor, but if you are armed with some basic Excel knowledge there are many ways to go about finding duplicates. When I first thought about this I came up with a couple of ways of finding duplicates pretty quickly, but as I have put more thought into it I have come up with several other ways... Continue reading
Click Like and get 15% discount on all our products right now!
Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
