Excel Formulas Archives - Page 80 of 112

How to Lookup Text in Excel (7 Methods)

May 15, 2024

Below is a dataset where employee names are provided with their Employee ID No and Email ID. Method 1 – Applying the LOOKUP Function to ...

How to Find from Right in Excel (6 Methods)

Jul 29, 2024

Let’s discuss how to use the Excel RIGHT function to find characters from the right in Excel. Below is a summary of the formulae used in this ...

How to Find from Right in Excel (6 Methods)

How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)

Jun 5, 2024

In this article, we’ll demonstrate how to count filtered data using the COUNTIF function together with the SUBTOTAL function. Download the ...

How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)

How to Use COUNTIF for Unique Text (8 Easiest Ways)

Jul 6, 2024

We'll use a sample dataset of sales information. The dataset contains two columns: Sales Person and Sales. Let's extract the unique values. ...

How to Use COUNTIF for Unique Text (8 Easiest Ways)

How to Calculate Due Date with Formula in Excel (7 Ways)

Jul 6, 2024

We have a dataset where some Project Names and their Starting Date and Total Days to complete these Projects are given in Column B, Column C, and ...

How to Calculate Due Date with Formula in Excel (7 Ways)

How to Use IF Formula with Dates (6 Easy Examples)

Jul 6, 2024

Excel IF Function Overview Description The IF function tests a condition, then returns one of the two values depending on whether the test is ...

How to Use IF Formula with Dates (6 Easy Examples)

How to Use COUNTIF Between Two Numbers (4 Methods)

Jul 3, 2024

The COUNTIF Function in Excel: Syntax ➤ Description Count cells within specific criteria. ➤ Generic Syntax COUNTIF(range,criteria) ➤ ...

How to Use COUNTIF Between Two Numbers (4 Methods)

How to Calculate Percentage of Total in Excel? (2 Methods)

Jun 15, 2024

Suppose you have a list of your daily or monthly transactions. You want to know in which transaction category you are spending the most. You can get ...

How to Calculate Percentage of Total in Excel? (2 Methods)

How to Use Excel WEEKNUM Function (5 Examples)

Jun 4, 2024

In this article, we’ll demonstrate various examples of how to use the WEEKNUM function effectively in Excel. Introduction to the WEEKNUM ...

How to Use Excel WEEKNUM Function (5 Examples)

How to Use the YEARFRAC Function in Excel – 7 Methods

Aug 10, 2024

This is an overview: The YEARFRAC Function in Excel Function Objective The YEARFRAC function is used to calculate the fraction of ...

How to Use the YEARFRAC Function in Excel – 7 Methods

Different Types of Lookup to Apply in Excel (8 Types)

Jun 14, 2024

Here's an overview of the functions and formulas for different types of lookups in Excel. What Is a Lookup in Excel? A lookup means ...

Different Types of Lookup to Apply in Excel (8 Types)

How to Use INDEX MATCH Instead of VLOOKUP in Excel

Jul 25, 2024

Excel INDEX Function The INDEX function returns a value or the reference to a value from within a table or range. The INDEX function is used ...

How to Use INDEX MATCH Instead of VLOOKUP in Excel

Conditional Formatting If Cell is Not Blank

Jun 12, 2024

Method 1 - Use the Conditional Formatting ‘Highlight Cell Rules’ Option If a Cell Is Not Blank Steps: Select the entire dataset B5:D13. ...

Conditional Formatting If Cell is Not Blank

How to Sum Multiple Rows in Excel (4 Quick Ways)

May 9, 2024

Download the Practice Workbook Sum Multiple Rows.xlsx 4 Quick Ways to Sum Multiple Rows in Excel Method 1 - Using the SUM ...

How to Sum Multiple Rows in Excel (4 Quick Ways)

How to Remove 0 from Excel (7 Methods)

Apr 24, 2024

When we work with spreadsheets not prepared by us, we face different types of number formats in cells. For example, phone numbers may contain leading ...