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 …
Excel Basics
Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.
Calculate Steel Pricing by hundredth weight (CWT)
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 »
Password Protect Excel Sheets
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 …
Fix Data Validation Greyed Out
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. …
Use FLASH FILL In Excel
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. …
Single Cell Text List with Dynamic Response
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 …