FILTER Function Archives - Page 11 of 11

FILTER Function

How to Find Unique Values from Multiple Columns in Excel

Feb 12, 2023 Excel Formulas

In this article, I will be showing how you can find unique values from multiple columns in Microsoft Excel. Download Practice Workbook ...

Copy Rows from One Sheet to Another Based on Criteria in Excel

Dec 22, 2022 Advanced Excel 1

In Microsoft Excel sometimes we need to copy rows from any worksheet to another worksheet based on different criteria. In this article, I will show ...

Excel INDEX MATCH with Multiple Criteria and Multiple Results

Feb 12, 2023 Excel Formulas 8

In this article, we are going to discuss an important topic which is “Excel INDEX MATCH with multiple criteria to find multiple results”. Finding the ...

VLOOKUP Formula to Compare Two Columns in Different Excel Sheets

Feb 14, 2023 Data Analysis with Excel 6

If you are searching for some special tricks to use the VLOOKUP Formula to compare two columns in different sheets then you have landed in the right ...

How to Create a Database in Excel (with Easy Steps)

Jan 18, 2023 Advanced Excel 9

Don’t know how to create a simple database in Excel? In this article, we will show you how you can make a database in Excel in just 7 simple steps. ...

5 Examples of Using Array Formula in Excel

Dec 20, 2022 Excel Formulas 12

If you are a regular user of Excel, you most likely know about the array formula in Excel. Also, you could be aware of this, array formulas lessen ...