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.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

Expertise

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

Experience

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

Latest Posts From Prantick Bala

0
If Cell is Blank Then Show 0 in Excel (4 Ways)

We have a dataset with production information of different factories. A unit is considered ready to sell when packaging is done. In the Unit Ready to sell ...

1
How to Remove Single Quotes in Excel (6 Ways)

Consider a dataset of product descriptions for some products. The texts in the product description column lie between single quotation marks. If you look at a ...

1
How to Clear Contents in Excel Without Deleting Formulas

The GIF below is an overview of clearing Excel values without deleting formulas. Here, a VBA code clears the contents without deleting formulas. When we run ...

1
How to Add Leading Apostrophe In Excel (4 Ways)

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

2
Conditional Formatting Entire Column Based on Another Column in 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 ...

1
How to Highlight Cells in Excel Based on Value (9 Methods)

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

1
How to Sum Values by Day in Excel (8 Easy Ways)

In this article, we’ll demonstrate 8 easy ways to sum values by day in Excel. Here is an overview: 8 Easy Ways to Sum Values by Day in Excel ...

1
How to Remove Decimals in Excel (13 Methods)

    In the sample dataset, there are a variety of different currencies, quantities and their exchange rate to USD. The decimals need to be ...

1
How to Remove Blank Spaces in Excel -7 Methods

This sample dataset contains cells with multiple blank spaces. Method 1 - Using the TRIM Function to Remove Blank Spaces Enter the following formula ...

2
How to Trim Right Characters and Spaces in Excel (5 Ways)

Sometimes data cells may have additional characters attached to the right which is not required.   In the sample dataset the Distance ...

1
How to use the SUMIF function with Multiple Criteria in Different Sheets in Excel – 3 Methods

This is an overview: The sample dataset showcases records of quarterly sales in three different sheets: Quarter 1, Quarter 2, and Quarter 3. Two ...

1
How to Insert a Total Row in Excel (4 Easy Methods)

We have a sample dataset below of different items, their prices, quantities purchased, and total prices. We will insert a total row in this dataset and get the ...

1
Split String by Character in Excel (6 Suitable Ways)

The sample dataset below contains the Contact Information of random people where Name, Email Address and Contact Number are entered as a single string and ...

0
How to Autofill a Column in Excel (7 Easy Ways)

Below you can see a dataset with missing entries. In this article, we’ll cover 7 methods that use autofill to fill up the empty cells. Method 1 - ...

0
How to Lookup and Return the Value in a Range in Excel – 5 Methods

This is an overview.   The following dataset has the Income Greater than, Income Lower than or Equal, and Tax Rate columns. Method 1 - ...

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

 

 

ExcelDemy
Logo