INDEX Function Archives - Page 3 of 7

Find Matches or Duplicate Values in Excel (8 Ways)

Oct 26, 2021 Excel Basics

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How to Calculate the Top 10 Percent in Excel (4 Ways)

Sep 22, 2021 Excel Formulas

At the time of working with numbers, we may need to find out or calculate the top 5, 10, or any specific percent in Excel. Generally, Excel provides ...

How to Auto Sort Multiple Columns in Excel (3 Ways)

Nov 2, 2021 Excel Basics

Data sorting is an amazing tool to arrange your information systematically as per your requirements. There are many cases when we need to sort ...

How to Lookup with Multiple Criteria in Excel (Both AND or OR Type)

Oct 27, 2021 Excel Formulas 1

While working in Excel, we are to do this often. We are to look up a particular value in a data set that satisfies one or more criteria. Today I will ...

How to use ISNA function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

Excel provides several information functions to provide you the necessary information and help you perform your desired tasks easily and swiftly. ...

How to Use CONCATENATE Function in Excel (4 Examples)

Nov 14, 2021 Excel Formulas

Today I will be showing how you can join two or more texts or numbers into one single text value using the CONCATENATE function of Excel. ...

How to Use LARGE Function in Excel (6 Easy Examples)

Nov 14, 2021 Excel Formulas

When we need to find a specific largest value, like the 2nd or the 3rd biggest number in any dataset. The Excel’s LARGE function returns numeric ...

How to use MATCH function in Excel (3 Examples)

Nov 1, 2021 Excel Functions

There are several lookup functions in Excel to perform various lookup and searching operations easily and swiftly. Today we are going to show you how ...

How to Use RANDBETWEEN Function in Excel (4 Examples)

Nov 2, 2021 Excel Formulas

Today I will be showing how you can use the RANDBETWEEN function of Excel to get any random integer between two given numbers. Read More: How to ...

How to Use FILTER Function in Excel (9 Easy Examples)

Nov 1, 2021 Excel Formulas

Excel 365 provides us a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using this ...

How to Use ROW Function in Excel (With 8 Examples)

Nov 16, 2021 Excel Formulas

When you have a tiny dataset, it’s easy to find the row number but in the case of a larger dataset, you may have to use the ROW function. In this ...

How to Use TODAY Function in Excel (6 Easy Examples)

Nov 17, 2021 Excel Formulas

The TODAY function is beneficial when we require to have the current date illustrated on a worksheet instead of opening the workbook. It is also ...

How to Sort Data in Excel Using Formula

Nov 17, 2021 Excel Formulas

Today I will be showing how you can sort any data using formula in Excel. Download Practice Workbook How to Sort Data in Excel Using ...

Sum Using OFFSET and MATCH in Excel (With Alternative Options)

Nov 12, 2021 Excel Formulas 2

Today I will be showing how you can determine any sum using OFFSET and MATCH in Excel from any set of data. Before going to the main discussion, ...

How to Filter Multiple Rows in Excel (11 Suitable Approaches)

Nov 18, 2021 Excel Formulas

In our practical scenario with Microsoft Excel, we have to filter columns as well as rows from a large range of data for analysis. In this article, ...