Excel Functions Archives - Page 16 of 29

How to Combine SUMIF and VLOOKUP in Excel (3 Approaches)

Jun 16, 2024

Overview: Excel SUMIF Function Objective: The function adds the cells specified by a given condition or criteria. Formula: ...

How to Combine SUMIF and VLOOKUP in Excel (3 Approaches)

How to use the VLOOKUP Function with Wildcards in Excel – 3 Methods

Jul 31, 2024

The dataset showcases ID, Name and Salary. To find the salary of a specific sales representative: Method 1 - Using the VLOOKUP Function ...

How to use the VLOOKUP Function with Wildcards in Excel – 3 Methods

How to Combine Multiple Rows into One Cell in Excel (6 Ways)

Jul 4, 2024

How to Combine Multiple Rows in One Cell in Excel: 6 Simple Methods We have the List of Favorite Fruits of Employees as our dataset. We have two ...

How to Combine Multiple Rows into One Cell in Excel (6 Ways)

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

VLOOKUP and Return All Matches in Excel (7 Ways)

Jul 3, 2024

Method 1 - VLOOKUP and Return Multiple Matches in a Column We have a table containing random names of several employees and their departments. We ...