Mahbubur Rahman

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

Combining LEN and SUBSTITUTE Functions You can use a formula combining LEN and SUBSTITUTE functions to count the number of characters within a cell. This is ...

Conditional Formatting is one of the most used Excel tools. Conditional Formatting allows us to format cells according to our criteria. In this article, we ...

In this article, we will learn how to Turn on Spell Check in Excel using the Review tab, shortcut key, and VBA code. But, let's first learn how to turn on ...

We will use a sample dataset containing Date, Product, Price, Quantity, and Sales. We'll lock some cells so they can't be edited. How to Lock ...

In this sample dataset, the Name values are in Text format, Weekly Income is in Currency Format and other cells are formatted with text and cell color. ...

We'll use the example dataset, which includes information on Region, Product, Quantity Price, and Sales. There are some blank cells in the Quantity column, ...

This is the sample dataset.   Method 1 - Using an Advanced Filter for a Cell That Contains Unique Text Values The dataset contains ...

Sometimes, when while working with a dataset we want to filter data and only want the visible cells and delete unfiltered rows in Excel. In this article, we ...

Our dataset contains empty rows, and we'll remove these empty rows in various ways. Method 1 - Manual Approach to Delete Empty Rows in Excel Steps: ...

We have attached a sample workbook containing sales information, including Date, Product, Country, Quantity, and Sales. How to Count Cells with a ...

Let's use a sample dataset containing Name, Gender, and Date of Birth to showcase how you can count how many cells contain dates in Excel. Method 1 ...

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

To make the data entry procedure more convenient, Excel converts some integers or strings to dates. Excel, on the other hand, does so without asking you, and ...

You'll learn how to convert Strings to Long in this VBA tutorial. This VBA tutorial comes with an Excel worksheet that contains all of the macros, data, and ...