Mizbahul Abedin

About author

Hello! Welcome to my profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was in Textile Engineering and management from Bangladesh University of Textiles. I am a Textile technology graduate with a great interest in research and development. I am very much passionate about my photography and won several prizes including an award from the Bangladesh tourism board.

Latest Posts From Mizbahul Abedin

How to Repeat Actions, Cell Values and Patterns in Excel (Complete Guideline)

In this Excel tutorial, you will learn: - How to redo actions - How to repeat cell values - How to repeat patterns - How to repeat formulas using the Fill ...

How to Create Stacked Waterfall Chart with Multiple Series in Excel

In this article, you are going to learn how to create a Stacked Waterfall Chart with multiple series in Excel. We will explore the benefits, best practices, ...

How to Remove Trace Dependents in Excel (3 Swift Ways)

In this article, we are going to show you how to remove trace dependents in Excel. We will know about some Excel features, keyboard shortcuts, and also Excel ...

How to Use Excel IF Statement for Increment by 1 (3 Examples)

In this article, we are going to show you how to use Excel IF statement for increment by 1. Along with the IF statement, we will also discuss the COUNTIF ...

How to Calculate Economic Order Quantity in Excel

EOQ, or Economic Order Quantity, is a mathematical model used in inventory management to determine the optimal order quantity for a company to minimize ...

How Do You Link Sheets in Excel with Index (3 Swift Ways)

In this article, we are going to show you how you link sheets in Excel with an index. We will apply the HYPERLINK link function, VBA macro, and also use the ...

How to Get Cell Value as String Using Excel VBA (4 Easy Ways)

In Visual Basic for Applications (VBA), working with cell values is a fundamental aspect of automating Excel tasks. While cells can contain various data types ...

[Solved!] Excel VBA “Argument Not Optional” Error

Excel VBA (Visual Basic for Applications) is a powerful tool that allows users to automate tasks, create custom functions, and enhance the functionality of ...

How to Use Excel VBA Do While Loop with Multiple Conditions

Excel VBA provides a robust set of tools for automating tasks and manipulating data. One essential feature is the Do While loop, which allows you to execute ...

How to Use Excel VBA to Call Private Sub from Userform

Looking for ways to use Excel VBA to call private sub from userform? Then, this is the right place for you. In Excel VBA, private subs are typically ...

How to Use VBA to Create Pivot Table from Named Range in Excel

In this article, we will explore the step-by-step process of using VBA to create a Pivot Table from named range using Excel VBA. Excel Pivot Tables are ...

How to Define VBA Global Array in Excel (2 Easy Ways)

In this article, we will explore the process of defining a global array in Excel VBA. We'll discuss the concept of module-level variables, their scope, and how ...

How to Use Excel VBA Text to Columns Date Format (2 Examples)

The article includes detailed step-by-step instructions on how to create a VBA macro that automates the Text to Columns process and converts text dates into ...

How to Sum If Cell Contains Number and Text in Excel

It is an informative article that provides solutions to a common problem encountered by Microsoft Excel users. This article discusses the challenge of summing ...

Excel INDIRECT Function with Named Range (2 Ideal Examples)

The article provides an in-depth explanation of how to use the INDIRECT function with Named Range in Microsoft Excel. The INDIRECT function accepts a string ...

Browsing All Comments By: Mizbahul Abedin
  1. Dear KRIS,
    Thanks for your feedback. We are extremely sorry that, we missed multiplying the formula by 2 (method-1). Now we have corrected the formula in the article, please try it now.
    If you still have any queries, please let us know in the comment section or our forum.

    Thanks and regards,
    Md. Mizbahul Abedin
    Excel & VBA Content Developer

Advanced Excel Exercises with Solutions PDF