Latest Blog Posts - Page 435 of 584

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

Jul 29, 2024

Dataset Overview In our dataset, we have information on the Quantity and Sales of various Product Categories, along with Order Dates and ...

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

How to Calculate First Day of Previous Month in Excel (2 Methods)

Jul 30, 2024

Method 1 - Use the EOMONTH Function to Calculate the First Day of the Previous Month Step 1: Enter the following formula in cell C5. ...

How to Calculate First Day of Previous Month in Excel (2 Methods)

Excel VBA: Cell Reference in Another Sheet – 4 Methods

Aug 3, 2024

This is the sample data set. Method 1- Reference Cells in Another Sheet with Excel VBA Copy the data in D5 in ‘Sheet2’ to ‘Sheet1’ Step 1: ...

Excel VBA: Cell Reference in Another Sheet – 4 Methods

How to Convert Number to Text with Commas in Excel (3 Methods)

Jul 25, 2024

Dataset Overview We will be working with the following dataset to demonstrate these methods. Method 1 - Using FIXED Function The ...

How to Convert Number to Text with Commas in Excel (3 Methods)

How to Make Empty Cells Blank in Excel (3 Methods)

Jul 4, 2024

The sample dataset below will be used for illustration purpose. It contains some products in column B and the total sales of each product in column ...

How to Make Empty Cells Blank in Excel (3 Methods)

How to Count Unique Values in Multiple Columns in Excel (5 Ways)

Nov 11, 2025

There is no easy way to compute the number of unique values in Excel. That's why we need to use formulas and do some manual tasks in Excel to Count ...

How to Count Unique Values in Multiple Columns in Excel (5 Ways)

How to Change Default Date Format from US to UK in Excel (3 Ways)

Jun 14, 2024

Consider the following dataset which represents five nominated movies in the best picture category for the Acadamy Awards (Oscars) in 2022. At first, ...

How to Change Default Date Format from US to UK in Excel (3 Ways)

How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)

May 23, 2024

Method 1 - Use the Apostrophe Symbol to Convert Number to Text with 2 Decimal Places in Excel Steps: Put an apostrophe sign (‘) in front of ...

How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)

How to use Excel VBA with an Advanced Filter – 6 Examples

Aug 15, 2024

This is the sample dataset. Example 1 - Use Excel VBA to Filter Data in the Current Location Set the criteria in B16:E17. Step 1: ...

How to use Excel VBA with an Advanced Filter – 6 Examples

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

Jul 29, 2024

Dataset Overview Imagine we have an Excel file containing data about various fruits exported by a businessman to different European countries. The ...

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

How to Use IF Statement in Data Validation Formula in Excel (6 Ways)

Apr 16, 2024

Here, we have some records of some of the products and their corresponding salesperson’s names of a company. By using this dataset, we will ...

How to Use IF Statement in Data Validation Formula in Excel (6 Ways)

Apply Custom Data Validation for Multiple Criteria in Excel (4 Examples)

May 25, 2024

In this article we'll discuss how to use Custom Data Validation with multiple criteria to prevent incorrect or out-of-range data being entered into a ...