Excel Formulas Archives - Page 63 of 112

How to Fill Cell with Color Based on Percentage in Excel (6 Methods)

Jul 1, 2024

Here's a dataset that contains the percentage of a company's sales from different months. We'll fill those cells with colors depending on the ...

How to Fill Cell with Color Based on Percentage in Excel (6 Methods)

How to Change Cell Color Based on a Value in Excel (5 Ways)

Jul 2, 2024

Method 1 - Dynamically Change Cell Color Based on a Value Consider the following dataset that shows U.S. state populations. We'll divide the ...

How to Change Cell Color Based on a Value in Excel (5 Ways)

How to Highlight Every 5 Rows in Excel (4 Methods)

Jul 29, 2024

In this article, we will demonstrate how to highlight every 5 rows in an Excel workbook using 4 different methods. We'll use the following dataset of ...

How to Highlight Every 5 Rows in Excel (4 Methods)

How to Find Duplicates without Deleting in Excel (7 Methods)

Jul 6, 2024

Method 1 - Use the COUNTIF Function to Find Duplicates in Excel without Deleting Steps: Enter the following formula in cell F5: ...

How to Find Duplicates without Deleting in Excel (7 Methods)

How to Find Highest Value in Excel Column (4 Methods)

May 30, 2024

We’ll use the following dataset to discuss 4 methods for finding the highest value in a Excel column. Method 1 - Find the Highest Value in ...

How to Find Highest Value in Excel Column (4 Methods)

How to Find Lowest Value in an Excel Column (6 Ways)

May 14, 2024

To demonstrate all the methods, we'll use the same dataset below. It shows Bitcoin prices by months in dollars. We'll look for the lowest price on ...

How to Find Lowest Value in an Excel Column (6 Ways)

How to Extract Text Between Two Commas in Excel: 4 Methods

May 25, 2024

Method 1 - SUBSTITUTE and MID Functions to Extract Text Between Two Commas Steps: Select cell C5 and write down the following formula for the ...

How to Extract Text Between Two Commas in Excel: 4 Methods

How to Extract Text after the Second Space in Excel – 6 Methods

Aug 7, 2024

The dataset contains information about Sales Amount and sellers' performance. To extract text from Column D: Method 1- Using the MID ...

How to Extract Text after the Second Space in Excel – 6 Methods

How to Extract Unique Items from a List in Excel – 10 Methods

Aug 3, 2024

Method 1 - Using the Excel Array Formula to Extract Unique Items from a List The following Product List contains ID No and Product Name. There is a ...

How to Extract Unique Items from a List in Excel – 10 Methods

How to Split Data into Multiple Columns in Excel (5 Methods)

Jul 28, 2024

Dataset Overview We'll use the following data set to split data into multiple columns using Excel functions. Method 1 - Using ...

How to Split Data into Multiple Columns in Excel (5 Methods)

How to Find Duplicates in Two Different Excel Workbooks (5 Methods)

Jul 6, 2024

Let’s assume we have two different datasets with a common field (Employee Name) in two different sheets in two workbooks. The first dataset is in ...

How to Find Duplicates in Two Different Excel Workbooks (5 Methods)

How to Extract Text after a Specific Text in Excel?

Jun 20, 2024

Method 1 - Using Flash Fill Feature to Extract Text after a Specific Text Steps: Enter the product name, Apple, from the code in ...

How to Extract Text after a Specific Text in Excel?

How to Count Columns until the Value is Reached in Excel – 2 Steps

Aug 11, 2024

The dataset showcases Sales Person , Target and units sold in Quarter-1. To calculate how many months they took to achieve their Target: ...

How to Count Columns until the Value is Reached in Excel – 2 Steps

How to Extract Text After Last Space in Excel (6 Ways)

Apr 30, 2024

In this article, I am going to use the below dataset for demonstrating purposes. In the range of cells B5:B11, long text in the Name & ...

How to Extract Text After Last Space in Excel (6 Ways)

How to Extract Text Between Two Characters in Excel: 4 Methods

Apr 16, 2024

Here is a dataset containing Reference and Client Code. Let's extract the text between two slashes. Read More: How to Extract Text Before ...