Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.
These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question... BUT one of the methods returns a different result. Make sure you understand why.
How can you get a unique list of values based on multiple columns? Use the hidden Google Sheets FLATTEN function to get a unique list of values from multiple columns. You just have to combine it with UNIQUE and you're done!
This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).
The new Excel LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster. How should you use this function and does it really make your files faster?
LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire early in their learning. This usually takes the form of