Nearly seven (seven!) years ago, I wrote a post that helped people compare two or more lists in Excel with ISNA and MATCH. It’s the second most popular post on Big Hungry Geek, right behind my post about merging worksheets in Excel, which has been the number one fan favorite for several years running. Since…

People compare lists (or columns) of information all the time, and Excel provides several easy ways to do it. Microsoft sums up several real-life examples quite nicely: For financial record-keeping, you often have to compare two lists to find data that appears on one but not on the other. Which new clients need to be…