Prantick Bala

About author

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.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.



Rhino3D, Maxsurf, C++, MS Office, AutoCAD, WordPress and Excel & VBA


  • Intern at Khulna Shipyard, Khulna, Bangladesh.
  • Probationary Officer at United Commercial Bank PLC, Bangladesh.

Latest Posts From Prantick Bala

Cannot Insert Column in Excel (All Possible Causes with Solutions)

In Excel, you may need to insert a column for adding new data. But sometimes you cannot insert a column in Excel in spite of your needs. In this article, I’ll ...

Excel Hyperlink with Shortcut Key: 3 Methods

Method 1 - Shortcut to Add Hyperlink in Excel The easiest way to add hyperlinks in Excel is to use a shortcut keyboard command. First, ➤ Select the cell ...

How to Highlight Active Row in Excel (3 Methods)

If your Excel dataset has a lot of columns, it becomes quite difficult to find data from one end to another end of a row. But if you generate a system in which ...

How to Remove Header and Footer in Excel (6 Methods)

Consider you have the following dataset with a Header. The dataset also has a Footer. Let's remove the Header and Footer from this dataset. ...

How to Use VBA Val Function in Excel (7 Examples)

The VBA Val function is an Excel Text function which converts a text string into a numeric value. You can use this function in a VBA code to get the starting ...

[Fix] The Pivot Table Name Is Not Valid (7 Causes with Solutions)

Sometimes you may face the error box saying that “The Pivot Table field name is not valid” when you are creating a Pivot Table. In this article, I’ll show you ...

Create Table in Excel Using Shortcut (8 Methods)

A table in Excel allows you to perform different calculations and organize your data more easily. You can create a table in Excel in different ways. In this ...

Hotel Bill Format in Excel (Create with Easy Steps)

Hotel Bill format is an invoice format that you can use to create hotel bills for clients in order to document information about hotel services as well as ...

Excel COUNTIFS Not Working (7 Causes with Solutions)

Excel COUNTIFS function counts values that match one or more criteria from a range. You may sometimes face the issue that the function is not properly working. ...

How to Group Duplicates in Excel (3 Easy Techniques)

Technique 1 - SUMPRODUCT Function to Group Duplicates ➤ Add the following formula in the first cell of the first empty column next to your dataset (E5), ...

How to Copy and Paste in Excel Using VBA (12 Methods)

Download Practice Workbook You can download the workbooks used to illustrate methods in this article from here. Excel VBA Copy Paste.xlsm Workbook ...

How to Use TIMEVALUE Function in Excel (4 Examples)

Excel TIMEVALUE function (a date & time function) converts a text time in a decimal number between 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). The text ...

How to Use CHAR Function in Excel (8 Suitable Examples)

Excel CHAR function (a Text function) gives a specific character when a valid number is given as the input. Some characters are hard to find, you can easily ...

Different Types of Lookup to Apply in Excel (8 Types)

Certainly, one of the frequent uses of Excel is looking up a value in a table or data range. Now, Excel contains a couple of dedicated lookup functions, in ...

How to Select Row in Excel If Cell Contains Specific Data (4 Ways)

Sometimes you may need to select an entire row based on any specific data in a cell of that row. In this article, we’ll show you 4 easy and simple ways to ...

Browsing All Comments By: Prantick Bala
  1. You are welcome, Adam. Feeling happy to know that this article has solved your problem.

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

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

Advanced Excel Exercises with Solutions PDF