COUNTIF Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/countif/ Bestselling Excel and Power BI Courses Tue, 21 Nov 2023 16:20:51 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png COUNTIF Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/countif/ 32 32 Excel’s Checkboxes Are Incredibly Cool! Here’s why https://www.xelplus.com/excel-checkboxes/ Tue, 21 Nov 2023 16:18:58 +0000 https://www.xelplus.com/?p=19747 Excel's new Checkbox feature makes lists and interactive reports easier than ever. See how to add, customize, and use the new checkbox feature in a creative and interesting ways.

The post Excel’s Checkboxes Are Incredibly Cool! Here’s why appeared first on Xelplus - Leila Gharani.

]]> Excel Find and Highlight Duplicates https://www.xelplus.com/excel-find-and-highlight-duplicates/ Thu, 24 Aug 2023 15:12:21 +0000 https://www.xelplus.com/?p=17558 Learn to locate duplicate values in a list, between multiple lists, as well as duplicate rows in a table. Generate a report that lists all duplicates.

The post Excel Find and Highlight Duplicates appeared first on Xelplus - Leila Gharani.

]]> How to Calculate Ratios in Excel https://www.xelplus.com/excel-calculate-ratios/ Thu, 25 Mar 2021 10:00:00 +0000 https://www.xelplus.com/?p=10178 Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios, you need to calculate the highest common factor. You can easily do this with the GCD function.

The post How to Calculate Ratios in Excel appeared first on Xelplus - Leila Gharani.

]]> Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) https://www.xelplus.com/excel-formula-hack-count-text/ Thu, 05 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11441 Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.

The post Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) appeared first on Xelplus - Leila Gharani.

]]> Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) https://www.xelplus.com/excel-rank-without-skipping-numbers/ Sat, 16 Mar 2019 14:54:00 +0000 https://www.xelplus.com/?p=12800 Learn about Excel's Rank and Rank.EQ functions. How can you rank values without skipping numbers in between and how to create a top 3 report with duplicates.

The post Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) appeared first on Xelplus - Leila Gharani.

]]> Find Multiple Matches in Excel & Create a Dependent Drop Down List https://www.xelplus.com/find-multiple-matches-in-excel-dependent-drop-down-list/ Thu, 15 Mar 2018 10:38:00 +0000 https://www.xelplus.com/?p=11023 In this tutorial, we will create a dependent drop-down list based on a messy Excel Table. For that purpose, we will extract all records for each category using the combination of INDEX and AGGREGATE. Next, we will fix the column referencing in the table. Finally, we will use a combination of OFFSET and COUNTIF to get a drop-down list restricted to non-empty cells.

The post Find Multiple Matches in Excel & Create a Dependent Drop Down List 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 Dependent Drop Down List with Tabular Data https://www.xelplus.com/excel-dependent-drop-down-list-tabular-data/ Thu, 09 Nov 2017 19:45:00 +0000 https://www.xelplus.com/?p=11799 How do you create conditional lists without name manager? You can use the offset formula directly in the data validation box. Watch this video to find out how.

The post Excel Dependent Drop Down List with Tabular Data appeared first on Xelplus - Leila Gharani.

]]> Corporate Report Makeover: Alternative for Excel Doughnut Charts https://www.xelplus.com/excel-report-makeover-alternative-for-doughnut-charts/ Thu, 19 Oct 2017 14:18:00 +0000 https://www.xelplus.com/?p=11866 Doughnut charts get a bad reputation, but they are still used in corporate reports. In this tutorial, we offer a better alternative. A bar chart with automatic sorting will tell the story in one glance. Learn, how to set it up.

The post Corporate Report Makeover: Alternative for Excel Doughnut Charts appeared first on Xelplus - Leila Gharani.

]]> 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) https://www.xelplus.com/excel-array-formula-unique-count-rows-excel-part1/ Thu, 19 Jan 2017 08:11:00 +0000 https://www.xelplus.com/?p=12721 Learn how to get the unique count across rows using an array formula based on the SUMPRODUCT and FREQUENCY functions.

The post 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) appeared first on Xelplus - Leila Gharani.

]]>