Latest Blog Posts

Excel VBA to Count Duplicates in a Column (A Complete Analysis)

While working with VBA in Excel, we often need to count duplicates in a column in a worksheet. In this article, I’ll show you how you can count ...

How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)

In this article, you will get to know about various ways to create a formula in Excel that will place the word Yes easily. Sometimes we want a result ...

How to Count Non-Blank Cells with Condition in Excel (6 Methods)

The dataset contains information about several students: student names, IDs, and marks secured in Physics and Chemistry. Method 1 – ...

How to Calculate Remaining Days in Excel (5 Methods)

We have an Excel file that contains information on the Start Date and End Date of different projects. We will use this worksheet to calculate the ...

How to Delete Selected Rows with Excel VBA (Step-by-Step Guide)

This article shows how to delete selected rows in Excel with VBA in the simplest possible way. Surely you can add or delete rows or columns manually ...

How to Count Duplicates in Two Columns in Excel (8 Methods)

Column B depicts the List of US Companies by Revenue (List-1) while column D shows the List of US Companies by Profit (List-2). We’ll count the ...

How to Create a Day Countdown in Excel (2 Examples)

Example 1 - Use the TODAY Function to Create a Day Countdown in Excel Here is a common template of the TODAY formula. We’re going to make a ...

Excel VBA to Copy and Rename a Worksheet Multiple Times

Below is a sample sheet named “Dataset” which we will use to illustrate how to duplicate a sheet multiple times and rename it in Excel using VBA. ...

Excel VBA to Copy Formula with Relative Reference (A Detailed Analysis)

While working with VBA in Excel, we often need to copy formula (s) with relative cell reference (s) from one range to another range. In this article, ...

How to Calculate Gross Profit Margin Percentage with Formula in Excel: 2 Methods

Method 1 - Excel Formula to Calculate Gross Profit Margin STEPS: Select the cell where you want to get the gross profit margin. Select cell E5. ...

Excel INDEX MATCH to Concatenate Multiple Results (With 2 Easy Steps)

While working in Microsoft Excel we might need to concatenate different multiple results from a particular dataset. In this article, we will ...

How to Copy Excluding Hidden Rows in Excel – 4 Easy Methods

This is the sample dataset. Method 1. Applying a Keyboard Shortcut to Copy Rows in Excel (Except Hidden Ones) Some rows are hidden in this ...

Excel Formula to Count Colored Cells in a Row (2 Effective Methods)

In this article, we will learn to count colored cells in a row with an Excel formula. Sometimes, we need to use colors to highlight certain cells in ...

How to Copy Rows to Another Worksheet Based on Criteria by Excel VBA: 2 Ways

Method 1 - Copy Rows To Another Worksheet Based on Text Criteria ➤ Press ALT+F11 to open the VBA window. In the VBA window, ➤ Click the Insert ...

Count Cells by Color with Conditional Formatting in Excel (3 Methods)

  The sample dataset contains the Salesman, Product, and Net Sales of a company. The Conditional Formatting feature in Excel is used ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo