UNIQUE Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/unique/ Bestselling Excel and Power BI Courses Tue, 12 Dec 2023 15:17:03 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png UNIQUE Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/unique/ 32 32 Office 2021 – New Functions and Enhancements https://www.xelplus.com/office-2021-new-features/ Thu, 14 Oct 2021 08:10:00 +0000 https://www.xelplus.com/?p=9771 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.

The post Office 2021 – New Functions and Enhancements appeared first on Xelplus - Leila Gharani.

]]> How To Remove Duplicates in Excel (3 Easy Ways) https://www.xelplus.com/excel-remove-duplicates/ Wed, 28 Jul 2021 17:27:00 +0000 https://www.xelplus.com/?p=9932 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.

The post How To Remove Duplicates in Excel (3 Easy Ways) appeared first on Xelplus - Leila Gharani.

]]> Google Sheets – How to Create a Unique List from Multiple Columns https://www.xelplus.com/sheets-unique-list-from-multiple-columns/ Wed, 28 Jul 2021 17:20:00 +0000 https://www.xelplus.com/?p=9943 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!

The post Google Sheets – How to Create a Unique List from Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Top 10 Tips to Make the Most of Google Sheets https://www.xelplus.com/top-10-tips-for-google-sheets/ Sun, 28 Feb 2021 22:02:00 +0000 https://www.xelplus.com/?p=10240 This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

The post Top 10 Tips to Make the Most of Google Sheets appeared first on Xelplus - Leila Gharani.

]]> When to Use the Hash Sign (#) in Excel Formulas https://www.xelplus.com/excel-hash-sign-formulas/ Thu, 21 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10332 What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

The post When to Use the Hash Sign (#) in Excel Formulas appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions https://www.xelplus.com/excel-functions-office-365/ Thu, 07 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10369 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 post How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions appeared first on Xelplus - Leila Gharani.

]]> Excel LAMBDA Function Explained https://www.xelplus.com/excel-lambda-function-explained/ Thu, 17 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=9037 With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 1, discover the LAMBDA logic and learn how to write your first Lambda.

The post Excel LAMBDA Function Explained appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s New LET Function https://www.xelplus.com/excel-let-function/ Thu, 13 Aug 2020 09:00:00 +0000 https://www.xelplus.com/?p=10815 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. Should you use this function in your files? Find out more in the complete tutorial.

The post How to Use Excel’s New LET Function appeared first on Xelplus - Leila Gharani.

]]> How to lookup all values between two dates in Excel with the FILTER function https://www.xelplus.com/excel-dynamic-arrays-filter-function-all-records-between-dates/ Sat, 15 Jun 2019 10:41:00 +0000 https://www.xelplus.com/?p=12318 Learn how you can use the new Excel dynamic arrays functions to filter all records between two dates. We'll use the new Filter function together with Sort and Unique functions.

The post How to lookup all values between two dates in Excel with the FILTER function appeared first on Xelplus - Leila Gharani.

]]> Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) https://www.xelplus.com/searchable-drop-down-list/ Fri, 25 Jan 2019 16:16:00 +0000 https://www.xelplus.com/?p=12998 This is the easiest searchable drop-down list you'll be creating in Excel. It uses the new Excel FILTER function and dynamic array functionality. Download the workbook to practice along.

The post Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) appeared first on Xelplus - Leila Gharani.

]]>