Excel Formulas Archives - Page 143 of 149

Excel INDEX MATCH Formulas with Returning Multiple Matches

Apr 19, 2024

Here we have a sales dataset consisting of the following columns: Brand, Device Type, Model No. and Units Sold. We want to get all results from the ...

Excel INDEX MATCH Formulas with Returning Multiple Matches

INDEX, MATCH, and COUNTIF Functions with Multiple Criteria

May 21, 2024

Let's use the following sample dataset to show how you can use these functions together. Method 1 - Combine INDEX and MATCH ...

INDEX, MATCH, and COUNTIF Functions with Multiple Criteria

How to Count Cells That are Not Blank in Excel – 8 Methods

Aug 3, 2024

The dataset contains dollar values in Accounting format. Method 1 - Using the COUNTA Function Steps: Go to D10 and enter the ...

How to Count Cells That are Not Blank in Excel – 8 Methods

Use INDEX MATCH for Multiple Criteria Without Array (2 Ways)

Jul 31, 2024

In this article, we will demonstrate two quick methods to use the INDEX and MATCH functions in Excel to sort some data matching multiple criteria ...

Use INDEX MATCH for Multiple Criteria Without Array (2 Ways)

Copy Rows from One Sheet to Another Based on Criteria in Excel

Aug 14, 2024

Method 1 - Use the Excel Filter Option to Copy Rows from One Sheet to Another Consider a dataset of some fruits with their unit price, weight, and ...

Copy Rows from One Sheet to Another Based on Criteria in Excel

How to Count Matches in Two Columns in Excel (3 Practical Methods)

Jun 8, 2024

Suppose you have the following dataset. Watch Video – Count Matches in Two Columns in Excel Method 1 - Count Matches in ...

How to Count Matches in Two Columns in Excel (3 Practical Methods)

How to Sum Cells with Text and Numbers in Excel

May 30, 2024

Method 1 - Using the SUBSTITUTE Function to SUM Cells with Text and Numbers The SUBSTITUTE function can separate the text from the numeric ...

How to Sum Cells with Text and Numbers in Excel

How to Auto Generate Number Sequence in Excel (9 Examples)

Apr 19, 2024

In this sheet, we have a table of 5 people with their ages. Let's auto-generate numbers for each of them. Generally, the serial numbers or IDs go to ...

How to Auto Generate Number Sequence in Excel (9 Examples)

How to Add Weeks to a Date in Excel (5 Ways)

Jun 23, 2024

To add weeks to a date, follow the steps below: Select a blank cell. Insert the formula: =(Date+Number of Weeks*7) Press Enter. If you ...

How to Add Weeks to a Date in Excel (5 Ways)

How to Minus Number of Days or a Date from Today in Excel

Jul 8, 2024

Method 1 - Subtract a Number of Days from Today Steps We put the number of days that are going to be deleted from today’s date in column B. ...

How to Minus Number of Days or a Date from Today in Excel

How to Add Days to Date Using Excel Formula (5 Easy Ways)

Jul 6, 2024

Watch Video – Add Days to Date Using Excel Formula Date Basics in Excel If we need to add dates to Excel, we can enter the ...

How to Add Days to Date Using Excel Formula (5 Easy Ways)

How to Add Years to a Date in Excel (3 Easy Ways)

Jul 6, 2024

Consider the following dataset. We'll add years to the joining dates. Method 1 - Using Simple Arithmetic to Add Years to a Date in Excel ...

How to Add Years to a Date in Excel (3 Easy Ways)

How to Calculate Growth Percentage with Formula in Excel

Jun 14, 2024

Method 1 - Calculating Growth Percentage Between Two Numbers in Excel To show this process, let’s assume we have a dataset of products with sales ...

How to Calculate Growth Percentage with Formula in Excel

How Do You Calculate Percentage Increase or Decrease in Excel

Jul 30, 2024

Method 1 - Calculate Percentage Increase or Decrease Using Generic Formula Select the cell where you want to calculate the percentage change and ...

How Do You Calculate Percentage Increase or Decrease in Excel

How to Calculate Salary Increase Percentage in Excel

Apr 26, 2024

Whenever our salary is increased, we usually have either of the two situations below. We have the Amount of Raise but want to find out ...