Latest Blog Posts

How to Keep Unique Values in a Drop Down List with Excel VBA – 3 Methods

Quick View: Sub Drop_Down_List_Unique_Values_At_Least_Once() List_Location = "B3" Data = Range(List_Location).Validation.Formula1 Data = ...

Excel VBA: Dynamic Range Based on Cell Value (3 Methods)

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the ...

How to Count Rows in Selection Using VBA in Excel

In general, a typical Excel workbook contains numerous rows. And these rows may have blank or non-blank entries. Excel VBA count rows in selection is ...

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 Count Columns with Data Using Excel VBA (2 Methods)

Method 1 - Count All the Columns with Data in a Worksheet Open the VBA editor by pressing ALT + F11. Create a new module from Insert > ...

How to Find and Replace Multiple Values in Excel with VBA (3 Examples)

Below is a dataset that contains information about the departments of employees. We will try to use VBA to find and replace the department's values. ...

[Fixed] Excel Formula Bar Not Showing Cell Contents

This article illustrates how to fix if the excel formula bar is not showing cell contents. Formula bar in excel allows us to enter or copy formulas. ...

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

Excel VBA: Count Rows with Specific Data (8 Examples)

We use Excel VBA code to perform work by simply clicking a single button only. In this article, we will discuss how to count rows with specific data ...

How to Find and Replace Text in Word Document Using Excel VBA (5 Methods)

Method 1 - Using Excel VBA to Find and Replace a Text String in a Word Document Open the Word document that contains the list of products. ...

How to Copy Filter a Drop-Down List in Excel (5 Methods)

Method 1 - Using an Advanced Filter Option to Copy a Filter Drop-Down List  We have the products listed in the Product column, but the products are ...

How to Find and Replace from List with Macro in Excel (5 Examples)

Example 1 - Find and Replace a Word from a List with Excel Macro In the following dataset, we want to find the product Cable and replace it with TV. ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo