You want to display today’s date? Or you want to check, if a date written in a cell is today? There is an easy formula: =TODAY()
One advanced scenario of Conditional Formatting is to use formulas to determine the format. Let’s say, you want to change the background color of cell A if cell B has a certain value.
One of the most often used functions when creating an Excel model is consolidating data from different sources. There are 3 major formulas for combining data from different tables or worksheets: VLOOKUP, SUMIFS and INDEX/MATCH. VLOOKUP and SUMIFS are rather popular whereas INDEX/MATCH is usually not that well known. So what is the difference between these… Continue reading When to use VLOOKUP, SUMIFS or INDEX/MATCH in Excel
Let’s assume, we have the following (although realistic) challenge: We got two lists which should have the same items in Excel. But they aren’t exactly the same so that we need to compare them. But how do we find out the best way, which items are missing in either one of the lists? Instead of… Continue reading How to Compare Two Lists in Excel