PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new places during travels, and enjoying movies and TV series in his downtime.
In Excel, if there is no data in any cell, it normally remains blank. But you can display 0 in the blank cells by following some techniques. In this article, ...
Sometimes we have data with single quotes in our Excel datasheet. If the data have single quotes Excel automatically hides the leading apostrophe of the ...
Oftentimes, we may want to remove values from our Excel spreadsheet. Now, what if we need to erase only the contents without affecting the formulas? Sounds ...
Excel may treat certain entries, particularly numbers that start with zeros, as formulas or numeric data. By adding a leading apostrophe to a cell entry, Excel ...
In Excel, conditional formatting is used to highlight any cells based on predetermined criteria and the value of those cells. We can also apply conditional ...
Let’s say we have a dataset where sales area and Number of units sold in different months of the first quarter by different salesmen are given. Now we will ...
You can make summations in Excel based on a specific date or day. In this article, we’ll show you 8 easy ways to sum values by day in Excel. 8 Easy ...
If the numbers of your dataset have decimals, you may want to remove them to make the dataset look simple. Removing decimals is quite easy; you can do it in ...
If your data set contains blank spaces which are unnecessary you may need to remove them. In this article, I’ll show you seven effective ways to remove blank ...
Sometimes our data cells may have some additional characters attached to the right which is not required. You can trim these characters from the right of your ...
Excel is the most widely used tool for dealing with massive datasets. If you have data across different sheets and want to sum those data based on multiple ...
Total row in Excel helps us get a quick summary of different columns from a table or a range of cells. In this article, I’ll show you 4 easy and quick methods ...
Sometimes you may have a dataset where different kinds of data are inserted in a cell and separated by a character such as a delimiter, a hyphen, a dash, etc. ...
Entering the same data multiple times is monotonous. It also consumes a lot of time. Excel offers smart features to autofill a column without retyping the same ...
If you want to look up certain criteria in a range and find the matching value, this article is the right place for you. I’ll show you 5 easy ways to lookup ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
You are welcome, Adam. Feeling happy to know that this article has solved your problem.
Thanks dar for finding the article helpful.
Would you please share your Excel sheet?
Then I’ll be able to understand what you are actually want to do and try my best to give you a solution.
Hello Paul,
I hope you have found your solution already. If not, please share your Excel workbook with me. It is difficult to say the reason for the error message without seeing your worksheet or code. I will try my best to solve your problem.