INDEX Function

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

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)

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)

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)

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)

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)

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)

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)

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)

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

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)

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)

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, ...

Excel Sort Dates in Chronological Order (6 Effective Ways)

Microsoft Excel presents various sort options. Sorting may differ in terms of our needs and conditions. What we need to know is the correct and ...

How to Arrange Numbers in Ascending Order in Excel Using Formula

Depending on different circumstances you may need to arrange numbers, among other things, in a certain order. You can quite easily do the task using ...

Excel OFFSET Dynamic Range Multiple Columns in Effective Way

Dynamic range expands automatically when you update the raw data to the range. It is so irritating to insert separate formula for the newly updated ...

ExcelDemy
Logo