How to find missing records using VLOOKUP() in Microsoft Excel Your email has been sent In Microsoft Excel, I have used many different solutions to compare lists. Sometimes the solution finds ...

Why? well, because it falls over helplessly when anyone attempts to use it as a database. It's really not queryable. Because it's impossible to audit. Same formula in all 3700 rows of a column?

When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...