COUNTIF Archives - Xelplus - Leila Gharani

COUNTIFS Function in Excel

Leila Gharani — Wed, 05 Jun 2024 06:22:14 +0000

Master the COUNTIFS function in Excel. Count cells based on multiple criteria with this powerful tool. Free practice file included.

The post COUNTIFS Function in Excel appeared first on Xelplus - Leila Gharani.

How to Insert a Check Mark in Excel

Leila Gharani — Sun, 28 Apr 2024 08:37:40 +0000

Learn how to insert check marks and cross marks in Excel and understand the difference between check marks and checkboxes.

The post How to Insert a Check Mark in Excel appeared first on Xelplus - Leila Gharani.

COUNTIF Function in Excel

Leila Gharani — Tue, 05 Mar 2024 15:22:33 +0000

Master the COUNTIF function with this expert guide. Perfect your skills in counting cells that fit specific conditions, boosting your efficiency and advanced data analysis. Discover COUNTIF's full range from basic uses to complex scenarios.

The post COUNTIF Function in Excel appeared first on Xelplus - Leila Gharani.

How to Insert a Checkbox in Excel

Leila Gharani — Tue, 21 Nov 2023 16:18:58 +0000

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 How to Insert a Checkbox in Excel appeared first on Xelplus - Leila Gharani.

Excel Find and Highlight Duplicates

Leila Gharani — Thu, 24 Aug 2023 15:12:21 +0000

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

Leila Gharani — Thu, 25 Mar 2021 10:00:00 +0000

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)

Leila Gharani — Thu, 05 Mar 2020 10:00:00 +0000

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)

Leila Gharani — Sat, 16 Mar 2019 14:54:00 +0000

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

Leila Gharani — Thu, 15 Mar 2018 10:38:00 +0000

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

Leila Gharani — Fri, 05 Jan 2018 14:19:00 +0000

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.