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

How to Create and Use ColorFunction in Excel (With Easy Steps)

In Excel, there is no function to make calculations based on the color of the cells. But by using Microsoft Visual Basic for Applications (VBA) it is possible ...

How to Remove Blank Lines in Excel (7 Easy Ways)

In this article, I will introduce you to 7 easy ways to remove blank lines in Excel. If your Excel dataset contains unnecessary blank lines or empty rows, you ...

How to Use IFERROR with VLOOKUP in Excel (5 Different Uses)

When the VLOOKUP function can’t find the lookup value in the lookup array, it will show an error sign, #N/A. But you can get rid of this problem by using the ...

INDEX Function to Match & Return Multiple Values Vertically in Excel

In this article, I’ll demonstrate how to use the INDEX function to match and return multiple values vertically in Excel. We will go through 2 easy ways to do ...

SUMIF Across Multiple Sheets in Excel: 3 Methods

In our datasheet, we have Quarterly sales by different salesmen across different sheets. Now we want to calculate the yearly sales of different salesmen. For ...

How to Calculate Years from Today in Excel (4 Easy Ways)

There is no built-in function to calculate the years between a past or future date and today’s date in Excel. However, you can do it by applying a combination ...

How to Compare Two Columns in Excel for Match (8 Easy Ways)

If you are looking for some special tricks to know how to compare two columns for match in Excel, you've come to the right place. We’ll show 8 suitable methods ...

How to Insert Excel Sheet Name from Cell Value (3 Easy Ways)

In many cases, you may need to use a sheet name from a particular cell value such as creating a sheet name from a cell value, referring to a sheet name from a ...

Count One Column If Another Column Meets Criteria in Excel

While using Excel, you may need to count for different values based on some specific criteria. Excel shines with enormous features to count different columns. ...

How to Find Last Cell with Value in a Row in Excel (6 Ways)

If you have a very large dataset, it can be quite time-consuming to find the last cell with value in a row in your Excel dataset. In this article, I’ll ...

How to Delete Column in Excel Without Affecting Formula (2 Ways)

You just can’t simply delete any column in Excel which has formulas in other columns. Doing this blindly will remove your hard-written formula and data. In ...

How to Calculate Difference Between Two Dates and Times in Excel

If you want to find out the difference between two dates or times in Excel, you will find this article useful. Here you can find how to calculate the ...

Absolute Reference in Excel (With Examples)

Absolute Reference in Excel is one kind of cell reference where the referred cell remains constant and doesn’t change when it is copied, moved or used in an ...

How to Copy a Sheet to Another Sheet in Excel (5 Easy Ways)

You may want to create copies of your worksheet for different reasons such as you may want to keep a backup, or you may want to do various calculations on the ...

How to Merge Rows Without Losing Data in Excel (5 Easy Ways)

In Excel, merging multiple rows, columns or cells is a common task. However, the fundamental problem in this task is that it only keeps data from the upper ...

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