Excel Formulas Archives - Page 85 of 112

INDEX-MATCH with Duplicate Values in Excel (3 Quick Methods)

Apr 25, 2024

Method 1 - Finding Duplicate Values in Excel with INDEX, MATCH, IF, and COUNTIF We have input some salespersons’ states and sales in the ...

INDEX-MATCH with Duplicate Values in Excel (3 Quick Methods)

How to Remove Print Lines in Excel (4 Ways)

Jul 6, 2024

We have a dataset with some dotted-lined borders. These page break lines show how much of the worksheet will be printed on a single paper. We need to ...

How to Remove Print Lines in Excel (4 Ways)

How to use the SUMIF function with Multiple Criteria in Different Sheets in Excel – 3 Methods

Aug 15, 2024

This is an overview: The sample dataset showcases records of quarterly sales in three different sheets: Quarter 1, Quarter 2, and Quarter ...

How to use the SUMIF function with Multiple Criteria in Different Sheets in Excel – 3 Methods

How to Remove Strikethrough in Excel (3 Ways)

Jun 3, 2024

To demonstrate our methods for removing strikethroughs from text in Excel, we'll use the following dataset: Method 1 - Using Keyboard ...

How to Remove Strikethrough in Excel (3 Ways)

How to Remove Extra Spaces in Excel (5 Easy Ways)

Jul 26, 2024

This article describes 5 ways to remove extra spaces in Excel. Here is an animated overview: We'll use the dataset below, and remove ...

How to Remove Extra Spaces in Excel (5 Easy Ways)

How to Remove Parentheses in Excel?

Aug 2, 2024

In this article, we will demonstrate 4 easy methods to remove parentheses in Excel. What Are Parentheses in Excel? In general, ...

How to Insert a Total Row in Excel (4 Easy Methods)

Jul 31, 2024

We have a sample dataset below of different items, their prices, quantities purchased, and total prices. We will insert a total row in this dataset ...

How to Insert a Total Row in Excel (4 Easy Methods)

How to Remove Space Before Text in Excel (4 Methods)

Apr 19, 2024

How Space Before Text Affects the Dataset? Space(s) before the text can create a lot of trouble to analyze a dataset. It may give you wrong ...

How to Remove Space Before Text in Excel (4 Methods)

How to Convert Serial Number to Date in Excel (7 Simple Ways)

Jul 30, 2024

Method 1 - Converting Serial Number to Date in Excel with Format Cells Option Steps: Select the C5:C16 cells >> Right-click to open the ...

How to Convert Serial Number to Date in Excel (7 Simple Ways)

Split String by Character in Excel (6 Suitable Ways)

Jun 18, 2024

The sample dataset below contains the Contact Information of random people where Name, Email Address and Contact Number are entered as a single ...

Split String by Character in Excel (6 Suitable Ways)

How to Calculate Date Range in Excel (4 Ideal Methods)

Jul 17, 2024

Method 1 - Using Arithmetic Formula to Calculate Date Range in Excel Enter the formula in Cell D5 and press Enter. =C5+7 The ...

How to Calculate Date Range in Excel (4 Ideal Methods)

How to SUM with IF Condition in Excel (6 Suitable Examples)

Jul 3, 2024

Here's an overview of using the SUMIF function to check how many values fulfill a condition. Download the Practice Workbook SUM IF ...

How to SUM with IF Condition in Excel (6 Suitable Examples)

How to Use SUMIF with Text in Excel (9 Easy Ways)

Apr 19, 2024

This tutorial uses a dataset for Product Name, Salesperson, and Profit, as shown below: Download Practice Workbook You can download the ...

How to Use SUMIF with Text in Excel (9 Easy Ways)

Using the COUNTIF Function to find if a Date Is within 7 Days – 2 Methods

Aug 13, 2024

Practice Workbook Download the following workbook and exercise. COUNTIF Date is within 7 Days.xlsx The Excel COUNTIF Function The ...

Using the COUNTIF Function to find if a Date Is within 7 Days – 2 Methods

How to Use the SUMIFS Formula with Multiple Criteria in Excel – 11 Methods

Aug 6, 2024

The sample dataset showcases Fruits, Region, Vendor, Quantity, Delivery Date and Sales. You want to sum Sales or Quantity values based on ...