Latest Blog Posts - Page 454 of 587

How to Calculate Production per Hour in Excel (4 Methods)

Jul 28, 2024

Method 1 - Using Target Efficiency and Working Period Start with a productive facility that has 6 working units. Each unit has its own machine ...

How to Calculate Production per Hour in Excel (4 Methods)

VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)

Nov 11, 2025

Sometimes we need to re-organize columns into rows when working on a large dataset in Excel for better readability. Implementing VBA is the most ...

VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

Aug 3, 2024

This is the sample dataset. Method 1 - Bold Text in the Output of the Concatenate Formula. Press ALT+F11 to open VBA. In the VBA window, ...

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

How to Autofilter and Copy Visible Rows with Excel VBA

Aug 9, 2024

The dataset below has 5 columns displaying a Site's name, Category, Date, Platform, and Number of Visits for each site. Method 1 – AutoFilter ...

How to Autofilter and Copy Visible Rows with Excel VBA

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

Aug 9, 2024

Importance of Cell Number Formatting in Percentage Calculation To enter a percentage you have to use Number format. Steps: Enter a decimal ...

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

Aug 6, 2024

The dataset showcases a list of colors with duplicates in Sheet1. To copy the unique colors to another worksheet in the same workbook. ...

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

Jun 3, 2024

Method 1 - Combine CONCATENATE, IF, and ISBLANK Functions to Concatenate Multiple Cells Consider the following dataset. In column B, we have ...

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

Carriage Return in Excel Formula to Concatenate (6 Examples)

Jul 4, 2024

Method 1 - Using Ampersand Operator and CHAR Functions Insert Carriage Return in Excel Formula to Concatenate Step 1: Insert the following formula ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

How to Calculate Average Turnaround Time in Excel (4 Methods)

Jul 4, 2024

Method 1 - Compute the Average Turnaround Time in Excel Look at the following picture. We have the Start Time and the End Time of some ...

How to Calculate Average Turnaround Time in Excel (4 Methods)

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

Jul 28, 2024

Method 1 - Concatenate a Date with Text and Keep the Date Format in Excel If you concatenate Text with Dates, then the Dates will be converted to ...

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

How to Convert Text Date and Time to Date Format in Excel – 7 Methods

Aug 14, 2024

In the dataset below date and time values are in Text Format (they are left aligned). Method 1 - Convert Text Date and Time to ...

How to Convert Text Date and Time to Date Format in Excel – 7 Methods

How to Count Filtered Cells with Text in Excel – 3 Methods

Aug 2, 2024

The sample dataset showcases Salesman, Product, and Net Sales of a company. There is a blank cell and a number in Column B. Method 1 - Using ...

How to Count Filtered Cells with Text in Excel – 3 Methods

Excel VBA to Count Cells Containing Specific Text

Nov 11, 2025

Sometimes we need to know how many times a certain text appears within a range of data in excel. For example, consider a dataset containing dates and ...

Excel VBA to Count Cells Containing Specific Text

How to Copy Merged and Filtered Cells in Excel: 4 Methods

May 29, 2024

Method 1 - Copy Merged Cells Using Paste Option Steps: Select the cells and press CTRL+C and paste it anywhere in the worksheet you want by ...

How to Copy Merged and Filtered Cells in Excel: 4 Methods

Run Time Error 1004 – PasteSpecial Method of Range Class Failed (4 Reasons and Solutions)

Jul 24, 2024

Reason 1 - Accessing PasteSpecial Method without Copying Anything The most common reason for this error is attempting to use the PasteSpecial method ...