Excel Formulas

How to Use a Formula to Find Bold Text in Excel (4 Methods)

Dataset Overview We'll use a dataset that holds products sold on certain days. The products that have sold a Quantity of more than 50 (>50) are ...

How to Copy a Cell to Another Sheet in Excel If the Cell Contains Text

The following dataset contains records of product codes, product lists, salesperson’s names, and corresponding sales values for a company. Using this ...

If Cell Contains Text Then Add Text in Another Cell in Excel: 6 Ways

To explain detecting and adding text to cells, let's use a sample dataset containing ID, Product Name, and Size.   Method 1 - If ...

How to Find the Last Non-Blank Cell in a Row in Excel (5 Methods)

Dataset Overview We'll use the below Dataset containing Employee Names and Working Hours. Method 1 - Using Excel LOOKUP Function The ...

How to Convert Date to Day of Year in Excel: 4 Methods

Method 1 - Convert Date to Nth Day of Year Using Excel DATE and YEAR Functions Step 1: An additional column beside the range. Inserting the formula ...

Compare Two Cells in Excel and Return TRUE or FALSE (5 Quick Ways)

Let’s consider a dataset (B5:D10) containing fruit names in two columns (columns B and C). We will compare fruit names between these columns and ...

How to Find a Character in String from Right in Excel (4 Methods)

The sample dataset contains information for a group of people who work in an office and have their own ID and User ID. Method 1 - Using ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo