Excel Functions Archives - Page 7 of 29

How to Vlookup a Partial Match for the First 5 Characters in Excel

Jul 12, 2024

Why Should We Use VLOOKUP Function for Partial Match? The VLOOKUP function fetches data from one table to another when the lookup value matches the ...

How to Vlookup a Partial Match for the First 5 Characters in Excel

How to Convert Excel ASCII to Char

Aug 11, 2024

American Standard Code for Information Interchange (ASCII) is a character encoding standard for electronic devices. In its 7-bit version, it supports ...

How to use the Excel VLOOKUP Function for a Partial Match in a Table Array – 3 Examples

Aug 15, 2024

Example 1 - Using Wildcards in the VLOOKUP Function to Look up a Partially Matched Text Steps: Prepare the dataset: assign cells to insert the ...

How to use the Excel VLOOKUP Function for a Partial Match in a Table Array – 3 Examples

How to Use the VLOOKUP Function with Multiple Criteria in Different Sheets – 4 Methods

Aug 11, 2024

The sample dataset is an overview. Method 1 - Using in VLOOKUP Function on Each Sheet Individually Steps: Create a dataset as shown ...

How to Use the VLOOKUP Function with Multiple Criteria in Different Sheets – 4 Methods

How to Get Cell Value by Address in Excel: 6 Simple Methods

Jul 7, 2024

Method 1 - Get Cell Value Using ADDRESS Function Steps: Go to cell D4 and insert the following formula: =INDIRECT(ADDRESS(10,2)) ...

How to Get Cell Value by Address in Excel: 6 Simple Methods

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way: 5 Methods

Jul 4, 2024

Method 1 - Use a Helper Column to Left to Match Multiple Criteria with VLOOKUP Steps: Create a helper column on the left side of your dataset. ...

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way: 5 Methods

Using the Excel COUNTIFS Function with Multiple Criteria and the OR Logic – 3 Examples

Aug 12, 2024

The sample dataset contains information about Products, their Payment Status and Quantity. To count the number of laptops and keyboards with ...

Using the Excel COUNTIFS Function with Multiple Criteria and the OR Logic – 3 Examples

Using the Excel COUNTIF Function with Multiple Criteria and a Date Range – 6 Examples

Aug 9, 2024

This is the sample dataset. Example 1 - Counting the Number of Different Dates Using the COUNTIF Function with a Multiple ...

Using the Excel COUNTIF Function with Multiple Criteria and a Date Range – 6 Examples

Vlookup with Time Range in Excel (5 Easy Ways)

Jun 30, 2024

In this article, we will demonstrate five quick methods to VLOOKUP within a time range in Excel. To demonstrate the methods, we'll use the dataset ...

Vlookup with Time Range in Excel (5 Easy Ways)

How to Lock Table Array in Excel (2 Effective Ways)

Jul 5, 2024

In this tutorial, I am going to show you 2 effective ways how to lock table array in Excel. You can apply these methods to any type of dataset and ...

How to Lock Table Array in Excel (2 Effective Ways)

How to Find Table Array in Excel: 4 Methods

Jul 3, 2024

Method 1 - Using Name Manager to Find Table Array in Excel Steps: Go to the Formulas tab. Click on the Defined Names group drop-down. ...

How to Find Table Array in Excel: 4 Methods

How to Name a Table Array in Excel (With Easy Steps)

Jul 9, 2024

Step 1 - Creating a Table Array Arrange the dataset. In this case, we have the Salesperson in Column B and two years, 2021 and 2022, in Columns ...

How to Name a Table Array in Excel (With Easy Steps)

How to Apply VLOOKUP to Return Blank Instead of 0 or NA

Jun 16, 2024

We will use a dataset with two columns, “Employee” and “Height(cm),” to demonstrate our methods. The value “Ross” is not listed on the primary ...

How to Apply VLOOKUP to Return Blank Instead of 0 or NA

How to Convert Date to the Week Number of the Month in Excel (5 Methods)

Jul 29, 2024

Dataset Overview Suppose we have a dataset containing sales records for a shop, including the date of each transaction. Our goal is to convert these ...

How to Convert Date to the Week Number of the Month in Excel (5 Methods)

How to Calculate a Logarithm in Excel (6 Methods)

Jul 16, 2024

What is a Logarithm? A logarithm is a mathematical operation that quantifies how a specific number, known as the base, grows by repeatedly ...