How to Get the Last Day of Month Using VBA in Excel (3 Methods)

This article illustrates 3 different methods to get the last day of the current, past, or future month from a specific starting date using VBA code ...

How to Combine Rows from Multiple Sheets in Excel (4 Methods)

Method 1 - Use Consolidate Option to Combine Rows from Multiple Excel Sheets The Consolidate feature is the quickest way to combine rows. But we can ...

How to Change Date Format in Pivot Table in Excel

Let’s introduce today’s dataset where Sales of some Product Categories is provided along with an Order Date and corresponding States. Creating ...

Create a Searchable Drop Down List in Excel (2 Methods)

The following picture highlights what you can do with a searchable drop-down. Imagine you have the following dataset in the worksheet ...

How to Use a Custom VLOOKUP Formula in Excel Data Validation – 2 Methods

The sample dataset showcases sales in different regions. Method 1 - Using a Drop-down List of Data Validation with the VLOOKUP Function in ...

Excel VBA: Count Unique Values in a Column (3 Methods)

  Overview of the Code Sub Number_of_Values_that_Appear_Only_Once_1() Set Rng = Range("C4:C15") Count = 0 For i = 1 To ...

Excel VBA with Cell Reference by Row and Column Number – 11 Examples

This is the sample dataset. Example 1 - Insert a Value in a Single Cell Using Reference by Row and Column Number with Excel VBA Step 1: ...

How to Find and Replace Cell Reference in Excel Formula

Most of the time we use a cell reference in an Excel formula. However, often we have to update the formula based on different situations. Now, if you ...

How to Convert Date to Month and Year in Excel (4 Ways)

  Suppose we have a dataset of several employees with DoB (date of birth) in column C. We want to convert the date to month and year only for ...

The AutoFit Row Height is Not Working for Merged Cells in Excel – 2 Solutions

Solution 1 - Use an Updated Version of MS Excel (2010, 2013, 2016, 2019, 2021, 365 Versions) This is the sample dataset. The Product column ...

How to Change Date Format in Excel Using Formula

To change date format using a formula in Excel: Select a cell. Insert the formula: =TEXT(Reference Cell,"Date Format") Press Enter. For ...

Excel VBA: Filter Date before Today (With Quick Steps)

In Microsoft Excel, working with dates is a pretty common thing. And filtering those dates is also a day-to-day task for a lot of Excel users. Now, ...

Excel VBA: Count Rows in Named Range (4 Methods)

We can count rows in a named range by using workbook functions or conditional formatting but if we work with a large amount of data then using VBA ...

[Fixed!] Arrow Keys Not Moving Between Cells in Excel (2 Ways)

A typical problem with arrow keys is that they move the spreadsheet but not the pointer. In this tutorial, we will illustrate how to fix arrow keys ...

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo