Transform List to Double-entry Table How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article
Compare 2 Columns You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values