Prantick Bala

About author

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

Latest Posts From Prantick Bala

How to Make a Dynamic Data Validation List Using VBA in Excel

In dynamic data validation, when you add a new entry to the source list, the entry is automatically added to the data validation list. It is a very efficient ...

How to Delete Infinite Columns in Excel (4 Methods)

Actually, Excel doesn’t have infinite columns. Excel 2007 and all the newer versions have 16384 columns in total. The number is so huge for most of the uses of ...

How to Count Duplicates Based on Multiple Criteria in Excel

In Excel, you may have duplicate data in the same columns. These data may be a part of a unique set when you consider all the data along a row. To be ...

How to Copy Worksheet to Another Workbook Using VBA

If you want to copy your Excel worksheet to another workbook or to a new workbook with Microsoft Visual Basic Application, this is the right place for you. In ...

How to Paste From Clipboard to Excel Using VBA

If you cut or copy any text or image, it will be saved in the clipboard first. After that, you can paste the text or image anywhere such as in Word files and ...

Excel VBA to Copy Rows to Another Worksheet Based on Criteria

Copying data, based on criteria, from one sheet to another is one of the frequently done tasks in Excel. If you have a lot of rows and want to copy them on ...

How to Bold Text in Concatenate Formula in Excel (2 Methods)

With the CONCATENATE function, you can join two or more texts altogether. Unfortunately, there is no way to bold text in the Concatenate formula directly. But ...

How to Add Leading Zeros in Excel by CONCATENATE Operation

In Excel, if you insert a number with leading zeros, the zeros will disappear. Excel does that because normally zeros in front of a number don’t convey any ...

How to Calculate the Duration of Time in Excel (7 Methods)

If you want to know how to calculate the duration of time in Excel, you will find this article helpful. In this article, I’ve discussed 7 different ways to ...

How to Calculate Net Profit Margin Percentage in Excel

Net Profit Margin is a financial and accounting term that expresses the ratio between net profit and total sales or revenue. It is calculated from the income ...

How to Calculate Average Percentage Increase in Excel

To find out your company's growth per year or to forecast the sales for next year, forecast the sales for next year you may need to calculate the average ...

How to Freeze Top 3 Rows in Excel (3 Methods)

While working with a large Excel worksheet, you may need to freeze different numbers of rows. It will allow you to navigate through your entire worksheet ...

How to Freeze Top Row and First Column in Excel (5 Methods)

While working with a large Excel worksheet, you may need to freeze the top row and first column. It will allow you to navigate through your entire worksheet ...

How to Rank Average in Excel (4 Common Scenarios)

Rank average is one of the methods of ranking data where the same values get an average rank. In Excel, there is an inbuilt statistical function- to rank data ...

How to Print Page Number in Excel (5 Easy Ways)

When you print an Excel sheet, you may want to print the sheet with page numbers. In this article, I’ll introduce you to 5 easy ways to print the page number ...

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