Excel Functions Archives - Page 25 of 40

How to Convert Multiple Rows to a Single Column in Excel

May 15, 2024

In the sample dataset, there are three rows: Team Red, Team Blue, and Team Green, with multiple columns. The goal is to convert it into a single ...

How to Convert Multiple Rows to a Single Column in Excel

How to Filter Duplicates in Excel (7 Suitable Ways)

Jun 18, 2024

Let’s get introduced to the data table first. We have a table that has 3 columns and 14 rows. The columns are named Ship Mode, Province, and Customer ...

How to Filter Duplicates in Excel (7 Suitable Ways)

How to Use the Excel VLOOKUP Function to Return Multiple Values Vertically – 5 Methods

Aug 11, 2024

Problems with the VLOOKUP When Returning Multiple Matches: In the dataset below there are three columns: Book Type, Book Name, and Author. To ...

How to Use the Excel VLOOKUP Function to Return Multiple Values Vertically – 5 Methods

COUNTIFS Unique Values in Excel (4 Easy Ways)

Jul 6, 2024

We’re going to use a Customer Record of Mars Group. This sample dataset includes some Product Names and Contact Addresses of the Customers who bought ...

COUNTIFS Unique Values in Excel (4 Easy Ways)

How to Find Text in Cell in Excel: 2 Suitable Examples

Jul 2, 2024

Method 1 - Combine SEARCH, ISNUMBER, and IF Functions to Find Text in Cell Steps: Select cell C5. Write down the following formula in the ...

How to Find Text in Cell in Excel: 2 Suitable Examples

How to Use VLOOKUP to Return Multiple Columns in Excel (4 Methods)

Jul 26, 2024

Method 1 - Using VLOOKUP with Array Formula Suppose you have a dataset with smartphone models and their specifications. To extract all ...

How to Use VLOOKUP to Return Multiple Columns in Excel (4 Methods)

How to Use TRANSPOSE Function in Excel?

Jul 30, 2024

Here's a quick view of the TRANSPOSE function in the following image. Introduction to the Excel TRANSPOSE Function Here are the syntax ...

How to Use TEXTJOIN Function in Excel (7 Suitable Examples)

Apr 24, 2024

Introduction to TEXTJOIN Function in Excel Summary Concatenates a list or range of text strings into a single string using a delimiter. ...

How to Use TEXTJOIN Function in Excel (7 Suitable Examples)

INDIRECT Function with Sheet Name in Excel (4 Practical Uses)

May 20, 2024

Method 1 - INDIRECT Function with Sheet Name to Refer Another Worksheet In the example image below, Sheet1 contains the names of donors and the ...

INDIRECT Function with Sheet Name in Excel (4 Practical Uses)

How to Use VALUE Function in Excel (5 Ideal Examples)

Jul 14, 2024

In this article we will demonstrate how to use Excel's VALUE function to convert various types of data into numbers. Here is an overview: ...

How to Use VALUE Function in Excel (5 Ideal Examples)

How to Reference Worksheet Name in Formula in Excel

Jun 24, 2024

Let’s consider the Sales Data for January in the “January” worksheet, which depicts the “Product Name” and the “Sales” in USD. We have the ...

How to Reference Worksheet Name in Formula in Excel

How to Use VLOOKUP Function with INDIRECT Function in Excel

Nov 11, 2025

If you are looking for ways to use a combination of the INDIRECT and VLOOKUP functions in Excel, then you will find this article useful. The INDIRECT ...