Lookup and Return Multiple Values Concatenated into One Cell in Excel

In Microsoft Excel, there are a number of suitable techniques to lookup a criterion and then return multiple values concatenated into one cell based ...

VLOOKUP to Return Multiple Values Horizontally in Excel

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

How to Sort by Date in Excel (8 Suitable Ways)

Today I will be showing how to sort a data set in Excel by date. While working in Excel, we often have to work with dates. From insertion to ...

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