Approximate match with XLOOKUP
Approximate match options in XLOOKUP adds a lot of flexibility to your lookup function. Make sure you have downloaded the workbook and can carry out all of the steps shown …
Course: Excel Skills to Make an Impression
SORT or SORTBY
The SORT function and SORTBY function will allow you to sort data, but both have very different use cases. The SORT function will sort a list but the SORTBY function …
Conditional Calculations
Excel has functions that allow for conditional calculations. These are calculations with conditions or criteria attached. These functions include SUMIF and AVERAGEIFS. Functions with IF and IFS attached are widely …
6 Reasons to use Tables in Excel
Quick totals. If you need to get totals quickly, convert your data into a table and the totals will be calculated for you. Quick formatting. You can quickly format a …
Logical tests, Comparative Operators and IF statements
Logical tests give a True or False statement and these can be calculated with the use of comparative operators. A logical test can be a comparison between two cell references …
How to lookup to the left
How can I lookup to the left? One of the limitations posed by VLOOKUP is that it can only look up to the right. But what if you want to …
Creating a Unique List in Excel
In this article, we are going to explore the first of our new Dynamic Array functions. The UNIQUE function. As the name describes, the UNIQUE function will allow you to …
