XLOOKUP with Multiple Criteria
In order to perform an XLOOKUP with multiple Criteria, you need to concatenate the lookup values and arrays. In our example, this is achieved by using “&” between […]
XLOOKUP with Multiple Criteria Read More »
Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.
In order to perform an XLOOKUP with multiple Criteria, you need to concatenate the lookup values and arrays. In our example, this is achieved by using “&” between […]
XLOOKUP with Multiple Criteria Read More »
Learn how to quickly calculate steel pricing by hundredth weight (CWT) using the following formula. For a quicker option, download the demonstration file. Quickly download the spreadsheet: Calculate
Calculate Steel Pricing by hundredth weight (CWT) Read More »
Learn how to quickly password protect an Excel Sheet. In Excel, you can quickly set password protection to any document. When a user, including yourself, opens the protected
Password Protect Excel Sheets Read More »
Have you ever run across the Data Validation box Greyed out in Excel? The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet.
Fix Data Validation Greyed Out Read More »
Learn how to use the FLASH FILL in Excel. Flash Fill quickly looks at similar cells and automatically picks up commonalities. Let’s look at the following data set.
Use FLASH FILL In Excel Read More »
Dealing with a single cell text list can be challenging in Excel. You cannot use VLOOKUP or XLOOKUP as search functions to returns results. Additionally, depending on the
Single Cell Text List with Dynamic Response Read More »