FILTER Function Archives

Sole Trader Bookkeeping Excel

Aug 16, 2023

This article will teach us how to create a sole trader bookkeeping Excel. Here, we will create a template and add all the information to complete the ...

How to Use SUMIF Function to Sum Not Blank Cells in Excel

May 11, 2023

Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the ...

How to Use SUMIF Function to Sum Not Blank Cells in Excel

How to Count Unique Values in Excel with Multiple Criteria

Jan 25, 2023

In this article, we will show you some methods to count unique values in Excel worksheet based on different criteria. The Excel worksheet can be used ...

How to Count Unique Values in Excel with Multiple Criteria

How to Use Custom Autofilter in Excel for More Than 2 Criteria

May 18, 2023

Excel spreadsheet can be used for custom autofilter for more than 2 criteria. This filter option is particularly useful for sorting a dataset. In ...

How to Use Custom Autofilter in Excel for More Than 2 Criteria

[Fixed!] Drop Down List Ignore Blank Not Working in Excel

Apr 29, 2023

Microsoft Excel is an intuitive tool that more than lives up to its illustrious reputation. We can perform many actions on a dataset thanks to ...

[Fixed!] Drop Down List Ignore Blank Not Working in Excel

Excel Formula for Finding Odd or Even Numbers

May 18, 2023

In this article, we will show formula for finding odd or even numbers in Excel. We will create Excel formula with common functions like IF, MOD, ...

Excel Formula for Finding Odd or Even Numbers

Artificial Intelligence in Excel (4 Examples)

Jan 4, 2023 2

Excel is a very powerful software for calculating and evaluating data. You can input your data and calculate the results along with different ...

Artificial Intelligence in Excel (4 Examples)

How to Pull Data from a Date Range in Excel (7 Handy Ways)

May 17, 2023

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious calculations, like Filter Date Ranges, in ...

How to Pull Data from a Date Range in Excel (7 Handy Ways)

Intersection of Two Columns in Excel (7 Easy Methods)

Feb 28, 2023

While working in Microsoft Excel sometimes we need to find intersection of two columns. But sometimes it becomes difficult if you are not aware of ...

Intersection of Two Columns in Excel (7 Easy Methods)

How to Separate Odd and Even Numbers in Excel (6 Handy Ways)

May 18, 2023

This article will show how to separate odd and even numbers in Excel. In addition to that, we will also see how to filter odd and even numbers and ...

How to Separate Odd and Even Numbers in Excel (6 Handy Ways)

List of Dynamic Array Formulas in Excel (7 Practical Examples)

Mar 13, 2023

In this tutorial, I am going to share with you 7 practical list of dynamic array formulas in Excel. You can easily apply these functions to perform a ...

List of Dynamic Array Formulas in Excel (7 Practical Examples)

Can Excel DGET Return Multiple Records [See 4 Solutions]

Mar 1, 2023

The DGET function in Excel is a database function and is designed to return only one record. In case you have multiple matches and need to return ...

Can Excel DGET Return Multiple Records [See 4 Solutions]

How to Calculate Quartile Deviation in Excel (4 Easy Methods)

Feb 9, 2023

This tutorial will demonstrate how to calculate quartile deviation in Excel. It is essential to use quartile deviation in almost every aspect of our ...

How to Calculate Quartile Deviation in Excel (4 Easy Methods)

How to Use Excel DGET with Dynamic Criteria (with Precise Steps)

Feb 8, 2023

Have you ever wondered how to apply the DGET function of Excel for multiple dynamic criteria? The DGET function of Microsoft Excel is one of the ...

How to Use Excel DGET with Dynamic Criteria (with Precise Steps)

[Fixed!] Error Messages in Excel (10 Practical Solutions)

Jan 4, 2023

Without hesitation, Microsoft Excel is one of the most compelling computer software you can use. Using Excel's tools and functions, we can do an ...