### Find Matches or Duplicate Values in Excel (8 Ways)

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 Sort Two Columns in Excel to Match (Both Exact and Partial Match)

While working in Excel, we often have to work with columns that are almost the same, and sometimes exactly the same. Today I will be showing how you ...

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

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)

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 Sort Multiple Columns in Excel Independently of Each Other

In Microsoft Excel, there are a lot of ways to arrange text data alphabetically, dates chronologically, and numbers from smallest to largest or from ...

### 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 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 HLOOKUP Function in Excel (8 Suitable Approaches)

In Microsoft Excel, HLOOKUP or Horizontal Lookup function is generally used to extract data from a table or an array based on searching for a ...

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