COUNTA Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/counta/ Bestselling Excel and Power BI Courses Mon, 11 Dec 2023 12:06:20 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png COUNTA Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/counta/ 32 32 Number Rows in Excel – Dynamic Solution with SEQUENCE https://www.xelplus.com/number-rows-in-excel-sequence-function/ Tue, 26 Sep 2023 14:08:36 +0000 https://www.xelplus.com/?p=18384 Learn how to create self-numbering lists for Excel tables and traditional lists using the SEQUENCE function.

The post Number Rows in Excel – Dynamic Solution with SEQUENCE appeared first on Xelplus - Leila Gharani.

]]> Excel Formulas and Functions Everyone Needs to Know https://www.xelplus.com/excel-formulas-and-functions/ Thu, 11 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10316 Learn how to use Formulas and Functions in Excel. I'll show you an Excel trick that will make it easier to find Excel functions and use them correctly. You'll learn how to use SUM, COUNT, COUNTA, AVERAGE, MAX, MIN and also more complex functions like AVERAGEIFS.

The post Excel Formulas and Functions Everyone Needs to Know 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 Create Excel Dependent Drop Down Lists on Many Rows https://www.xelplus.com/excel-dependent-drop-down-every-row/ Thu, 26 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11410 Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

The post How to Create Excel Dependent Drop Down Lists on Many Rows appeared first on Xelplus - Leila Gharani.

]]> Practical Excel Dashboards Tips – Ideas to Get Creative https://www.xelplus.com/excel-hash-2019/ Wed, 11 Dec 2019 03:18:00 +0000 https://www.xelplus.com/?p=11674 This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You'll find a lot of hidden gems in the way this Excel dashboard was created.

The post Practical Excel Dashboards Tips – Ideas to Get Creative appeared first on Xelplus - Leila Gharani.

]]> Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Expandable Conditional Drop Down Lists in Excel https://www.xelplus.com/excel-dynamic-dependent-drop-down-lists-exclude-blanks/ Fri, 20 Jul 2018 07:16:00 +0000 https://www.xelplus.com/?p=10085 Quickly create dynamic drop-down lists in Excel that are dependent on another list. Automatically exclude blank cells and allow the drop-down to expand as new values are added.

The post Expandable Conditional Drop Down Lists in Excel appeared first on Xelplus - Leila Gharani.

]]> Extract Unique Items for Dynamic Data Validation Drop-Down List https://www.xelplus.com/extract-unique-items-for-dynamic-data-validation-drop-down-list/ Fri, 05 Jan 2018 14:19:00 +0000 https://www.xelplus.com/?p=11193 Learn how to extract unique items from a list that contains multiple instances of each item, and use this list in a dynamic dropdown so that any time the list expands, your data validation list is updated. The solution will work in any Excel version, no Office 365 required.

The post Extract Unique Items for Dynamic Data Validation Drop-Down List appeared first on Xelplus - Leila Gharani.

]]> Excel Index Dynamic Range to find First Empty Cell https://www.xelplus.com/index-dynamic-range/ Sun, 05 Feb 2017 14:33:00 +0000 https://www.xelplus.com/?p=12665 Learn how to create a description column that includes the number of sub-items within a main item and also provides the description of the main item. You can achieve that in Excel with a formula combining the COUNTA, INDEX and MATCH functions.

The post Excel Index Dynamic Range to find First Empty Cell appeared first on Xelplus - Leila Gharani.

]]> Excel OFFSET Function for Dynamic Calculations https://www.xelplus.com/excel-offset-function-for-dynamic-calculations/ Tue, 17 Jan 2017 15:45:00 +0000 https://www.xelplus.com/?p=12974 Think of the OFFSET function as a GPS for your spreadsheet. You give it a starting point and then you tell it how many rows to go down, how many columns to move across, and what range you want returned. Master OFFSET with the help of this tutorial, which looks at calculating the average for the last six months in a dynamic way.

The post Excel OFFSET Function for Dynamic Calculations appeared first on Xelplus - Leila Gharani.

]]>