When to use VLOOKUP, SUMIFS or INDEX/MATCH in Excel
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 3 formulas and which one should you use? […]
How to Compare Two Lists 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 comparing manually, there are some easy steps. […]
Unhide All Hidden and Very Hidden Worksheets in Excel at Once
Unhiding hidden worksheets in Excel can be troublesome, especially if there are many hidden worksheets in your workbook. Usually, you would right click on any worksheet name on the bottom of the window and press “Unhide”. You can then choose one (and only one) worksheet at the same time for unhiding. After unhiding three worksheets like this, you will start feeling annoyed. After 10, you are going to hate Excel…
[…]
How to Get the Name of an Excel Worksheet
Often, you need to display and work with the sheet name, for example if you are working with the ‘INDIRECT’-formula. If you don’t want to type the sheet name manually – which is very unstable – there are three ways to get a sheet name:
[…]