Excel Functions Archives - Page 22 of 40

How to Unhide Columns in Excel (8 Methods)

Nov 11, 2025

In this article, we are going to illustrate 7+ methods with examples to unhide columns in Excel. The feature to hide a column in Excel makes columns ...

How to Unhide Columns in Excel (8 Methods)

How to Select Specific Data in Excel (6 Easy Methods)

Jun 12, 2024

We have a datasheet where ID, Marks, and Student Names are given in columns B, D, and C, respectively. We will use the dataset to select ...

How to Select Specific Data in Excel (6 Easy Methods)

Why VLOOKUP Returns #N/A When Match Exists (with Solutions)

Jun 12, 2024

We will be using a sample product price list as a dataset to demonstrate all the reasons. Reason 1 - Lookup Value Doesn’t Exist in the ...

Why VLOOKUP Returns #N/A When Match Exists (with Solutions)

INDEX MATCH vs VLOOKUP Function (9 Practical Examples)

Jul 29, 2024

Here's an overview of using the INDEX-MATCH and the VLOOKUP functions in a dataset. INDEX-MATCH vs. VLOOKUP Function in Excel: 9 Examples ...

INDEX MATCH vs VLOOKUP Function (9 Practical Examples)

How to Use Nested VLOOKUP in Excel: 3 Methods

Jul 5, 2024

Method 1 - Using Nested VLOOKUP in Excel to Extract Product Price Steps: Click on the cell that you want the Price of the ID (e.g. cell beside ...

How to Use Nested VLOOKUP in Excel: 3 Methods

How to Sum Columns in Excel – 7 Methods

Aug 3, 2024

The following dataset represents the order summary of 6 products. To show details of the orders throughout the year: Method 1 - Getting ...

How to get Excel to Recognize Numbers in Cells (3 Techniques)

Jun 17, 2024

Below is a dataset with some formatted numbers. Method 1 – Using the Number Format Command Steps: Select the range of cells B5:B10. ...

How to get Excel to Recognize Numbers in Cells (3 Techniques)

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

Jun 14, 2024

Method 1 - Using Find and Replace Step 1: Go to Home Tab > Select Find & Select (in Editing section) > Click on Replace (from the ...

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

Conditional Formatting Multiple Text Values in Excel (4 Easy Ways)

Apr 27, 2024

Consider a dataset of Product Sales, where we have text value columns named Region, City, Category, and Product. We want to conditionally format the ...

Conditional Formatting Multiple Text Values in Excel (4 Easy Ways)

How to Trim Right Characters and Spaces in Excel (5 Ways)

Jun 17, 2024

Sometimes data cells may have additional characters attached to the right which is not required. In the sample dataset the ...

How to Trim Right Characters and Spaces in Excel (5 Ways)

How to Check If a Value Is in List in Excel (10 Ways)

Jul 2, 2024

Consider a dataset about some products of a company. We will check whether specific values in the Product column exist. Method 1 - Using ...

How to Check If a Value Is in List in Excel (10 Ways)

How to Calculate the Average in Excel – 11 Methods

Aug 15, 2024

Download Practice Workbook Download the Excel workbook. Calculate Average.xlsx Method 1 - Calculating the Simple Arithmetic Average of ...

How to Calculate the Average in Excel – 11 Methods

How to Use Left Trim Function in Excel: 7 Easy Ways

Jul 6, 2024

Some spreadsheets like the following sample dataset require us to trim data from the left. Here, we need to trim the Color from the given Product ...

How to Use Left Trim Function in Excel: 7 Easy Ways

How to Remove Trailing Spaces in Excel (6 Easy Methods)

Nov 11, 2025

While working in Excel, we often encounter hasty inputs of trailing spaces in cells. Whatever the reasons may be, existing trailing spaces pose ...

How to Remove Trailing Spaces in Excel (6 Easy Methods)

How to Remove the Dollar Sign in Excel – 7 Methods

Aug 3, 2024

The pre-formatted dataset shows the dollar sign ($) before the Price value. Method 1- Using the Format Cells Feature to Remove the Dollar ...