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 ...
Mahbubur Rahman
We need to count words while publishing an article, submitting an assignment, to see how many characters are going onto a business card, etc. We are going to ...
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 ...
While working in Excel, Excel might not correct all the spelling mistakes but it offers some methods to automatically check spelling mistakes. We will see 3 ...
To protect our spreadsheet, we need to know how to lock certain cells in Excel. Locking the whole spreadsheet or certain cells in Excel allows us to protect ...
Sometimes while working in Excel we need to copy cells. But sometimes while copying the format of the cells may change which will make our task difficult if we ...
When performing calculations in Excel, sometimes we want the results to be displayed as a blank cell if the computation does not meet our needs. When we use ...
Advance Filter in Excel is one of the coolest options in Excel. Advance Filter can do many complex filtering that AutoFilter can not do. In this article, we ...
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 ...
Sometimes, while using Excel we have to deal with different sizes of datasets which may contain blank cells at the bottom or in between rows. Here, we will ...
Coloring cells is a popular method to visualize data in an Excel worksheet. Sadly, there is no in-built function in Excel to do it. We're going to show you ...
Excel sheets can be used to keep track of time, and date, schedule events, and activities, keep track of objects and their prices, and much more. In this ...
Copying merged and filtered cells in Excel can be a frustrating process. Merged and filtered cells are notorious in spreadsheets for producing problems, ...
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 ...
