Excel Formulas

How to Add Characters in Excel (with Formula, Flash Fill & VBA)

Here's an overview of a method where characters are added using Flash Fill. Download the Practice Workbook Add Characters.xlsm ...

How to Remove Partial Data from Multiple Cells in Excel (6 Methods)

Dataset Overview To make the explanation clear, we'll use a dataset representing product information from a fruit shop, but some information is ...

How to Align Two Sets of Data in Excel (6 Examples)

  Below is a dataset showing two columns: Product List 1 and Product List 2. Next to them is a separate column, Aligned Dataset, where the ...

Change Font Color Based on Value of Another Cell in Excel

In this tutorial, we will demonstrate how to change font color based on the value of another cell. Here is an overview of the process. To ...

COUNTIF Excel Example (22 Examples)

Here's a sample dataset that will be used to demonstrate how to use the COUNTIF function. Download to Practice COUNTIF Excel ...

How to Perform Data Validation for Alphanumeric Only in Excel

Method 1 - Using a Custom Formula to Data Validate Any Alphanumeric STEPS: Use the following formula in the C5 cell. ...

Excel Find Matching Values in Two Columns

Method 1 - Find Matching Values in Two Columns Using the IF Function We have two lists of fruit names and want to find matching fruit names between ...

How to Paste Range Names in Excel (7 Ways)

In this article we will demonstrate some of useful ways to paste range names in Excel. Pasting range names can simplify working in Excel, ...

How to Remove First 3 Characters in Excel (4 Suitable Methods)

Consider a situation where you have a dataset containing raw data, where the first 3 characters are unnecessary and need to be removed. ...

How to Highlight Cells in Excel Based on Value (9 Methods)

Let’s say we have a dataset where sales area and Number of units sold in different months of the first quarter by different salesmen are given. Now ...

How to Copy Values to Another Cell If Two Cells Match in Excel: 3 Methods

In this article, we will use a sample product price list as a dataset to demonstrate all the methods.   Method 1 - Use IF Function ...

How to Highlight Row If Cell Contains Any Text in Excel

Here's a GIF overview of using conditional formatting to highlight rows based on certain values inside them. How to Highlight Row If the ...

How to Remove Letters from Cell in Excel (10 Suitable Methods)

Here's a quick overview of the function that can remove text based on how many characters you want to keep. Read on to learn all the methods you can ...

How to Delete Everything After a Character in Excel -7 Methods

Method 1 - Applying the Find and Replace Option to Delete Everything After a Character in Excel Steps: Select the dataset (B5:B9). ...

Excel Formula to Compare and Return Value from Two Columns

We'll use a simple dataset of employees assigned to two projects for a few of the methods. Method 1 - Combining Excel IF and EXACT Functions to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo