Excel Formulas

How to Find the * Character (Not used as a Wildcard) in Excel – 2 Methods

This is an overview: Press CTRL+F and enter asterisk (*) in the search box. If you click Find Next, no results will be displayed. ...

How to Use Formula for Past Due Date in Excel (3 Methods)

To demonstrate how to use formulas for due dates, we'll use a dataset containing data titled Project Name and Deadline. How to Use a ...

How to Find the Last Row with a Specific Value in Excel (6 Methods)

Here, we have a sample dataset containing Customer Name, Gender, Loan Purpose, Job, and Credit Risk. The dataset is repetitive. Snoop, Almanda, and ...

How to Return YES If 2 Cells Match in Excel (10 Methods)

Below is a dataset that contains the names of the school's tennis and rugby players. Some of them play both games. Method 1 - Use the ...

Compare Two Cells Using Conditional Formatting in Excel (3 Methods)

We have a dataset of 3 columns titled Yearly Revenue Statement. The first column contains different unit names. The second and third column contain ...

Excel Find Last Occurrence of Character in String (8 Methods)

Our sample dataset has three columns: Company Name, Employee Code, and Last Occurrence. Employee Code contains the name, age, and department of an ...

How to Find the First Value Greater Than in Excel (4 Methods)

Dataset Overview We have a dataset with columns for State Name (Column B), Budget Allocation (Column C), and Region (Column D). We'll identify the ...

Dynamic Sum Range Based on Cell Value in Excel: 4 Ways to Create

Method 1 - Use INDEX Function to Create Dynamic Sum Range Based on Cell Value in Excel We will use a dataset that contains information about the ...

How to Set Due Date Reminder in Excel (3 Quick Methods)

We’ll use the following dataset that represents some buyers’ invoice amounts and due dates. Method 1 - Combine TODAY, AND, and IF ...

How to Convert Date to Day in Excel (7 Quick Ways)

The sample dataset contains Festival’s Name and Date. We will convert the Date to Day. Method 1 - Adopting Format Cells Feature to ...

How to Convert Date to Month in Excel (6 Easy Methods)

We will be working on the following dataset. Convert a Date to Month in Excel: 6 Methods Method 1 - Converting a Date to the Month with ...

How to Use Excel Formula to Find Last Row Number with Data: 2 Easy Ways

In this article, we will use an Excel formula to find the last row number with data for two cases – either when the last row is blank or when it is ...

Excel Formula for Current Month and Year (3 Examples)

Let's use the following dataset that represents some gadgets’ order date at a store. Here the order dates are the current date and the dates are in ...

VLOOKUP Date Range and Return Value in Excel: 4 Methods

Let’s introduce today’s dataset where the name of the Items is provided along with Order Dates, Unit Price, Quantity and Sales. Method 1 - ...

How to Use IF Formula for Date Range in Excel (6 Methods)

We’ve taken a sample dataset with three columns: Products, Shipping Date, and Status. We’ll check if a date falls between a range, equals a range, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo