Zahid Hasan

About author

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in these domains.


Junior Software Developer for the Excel Add-in project

Lives in

Dhaka, Bangladesh.

Education in Industrial and Production Engineering (IPE), Bangladesh University of Engineering and Technology.


VBA, VB.Net, Microsoft Office, Content Writing.


  • Technical Content Writing
  • Junior Software Developer


  • Currently working as Junior Software Developer for the Excel Add-in project of ExcelDemy
  • Started technical content writing in Excel & VBA in June 2022 and now working as a Junior Software Developer.

Latest Posts From Zahid Hasan

How to Statistically Analyze Data in Excel (5 Useful Ways)

Statistical data analysis is quite common to analyze and interpret our data in scientific way. It helps us to find trends of data and also to take decisions ...

Excel Pie Chart

In this article, we will learn about Pie Chart in Excel. We will explore different components of a Pie Chart and various methods to edit a Pie Chart in Excel. ...

Excel Pivot Table Filter Based on Cell Value (6 Handy Examples)

While working in Excel, we often need to use Pivot Tables. Using the Filter option in Pivot Tables is a great way to summarize data. We can filter our data in ...

How to Use Excel VBA VLookup with Named Range (5 Examples)

Microsoft Excel is one of the most widely used spreadsheet software in the world. Excel allows us to write codes and create macros to automate our tasks. ...

How to Create Data Validation with Checkbox Control in Excel

In this article, we will discuss five simple steps to create Data Validation with Checkbox control in Excel. 5 Easy Steps to Create Data Validation with ...

How to Use DPRODUCT Function in Excel (6 Practical Examples)

While working in Excel, we often need to use various Database Functions. The DPRODUCT function is one of the most widely used database functions in Excel. The ...

How to Clear Pivot Table Cache Using VBA in Excel

In Excel, we often need to use the PivotTable option to summarize our data. If we delete some data from the source table of the Pivot Table, some cells will be ...

How to Do Union of Two Columns in Excel (5 Easy Ways)

In Excel, we often need to do union of two columns. We can manually merge two columns in Excel. But for a large, this will require a lot of time. Whereas, we ...

How to Convert Old Excel Files to New Format (2 Quick Ways)

While working in Excel, we often need to deal with Excel files in an old format. As a result, we encountered a number of compatibility issues. To solve this ...

How to Draw a Circle in Excel with Specific Radius (3 Methods)

While working in Excel, we often need to draw circles in our worksheets. In Excel, there is no specific command or option to draw a circle. But Excel allows us ...

How to Calculate Standard Deviation of y Intercept in Excel

We often need to measure standard deviation in statistical datasets. We can calculate the standard deviation of the y intercept in Excel. In this article, we ...

[Fixed!] External Data Connections Have Been Disabled in Excel 

While working in Excel, we often encounter a warning message like this, "External Data Connections have been disabled" when we open an Excel file. A number of ...

How to Create Floating Text Box in Excel (2 Easy Ways)

While working in Excel, we often need to create a floating text box. A floating text box allows us to display the contents of a cell anywhere in an Excel ...

How to Filter Using RegEx in Excel (with Simple Steps)

If you are trying to filter RegEx patterned values in Excel, then this article will serve the purpose. RegEx is the acronym for "Regular Expression”. ...

How to Find ZIP Code from Address in Excel (2 Easy Ways)

Finding the ZIP Code or Postal Code can be a troublesome job to do in Excel if you don’t know the correct procedure. But it’s rather quite an easy thing to do. ...

Browsing All Comments By: Zahid Hasan
  1. I am sorry to hear that. Could you maybe describe which step of the procedure you are having trouble with so that I can clear up any confusions? Both methods worked fine for me. I have got the following output using these methods.

  2. Dear AL,
    Thank you for your query. So, your goal is to import data from a CSV file that has a column named ID with 20 digits in each cell of the column. You can use the following procedure to avoid converting the data into scientific notation while importing the CSV file.
    First, create a CSV file with the required data. For demonstration, I have used the following data.

    Now, go to the Data tab >> click on From Text/CSV.
    Then navigate to your file and select it >> click on Import.
    Next, click on the drop-down button >> choose the Do not detect data types option >> click on Load.

    That’s it! Your data has been successfully loaded into Excel without any conversion to scientific notation or data loss.

    I believe this has addressed your query. If you require additional support, please don’t hesitate to inform us.


    Thank you for your query. To create a search box that will search data based on a provided date, you can follow the steps given below.
    First, construct a search box and add this code to it.

    Private Sub TextBox1_Change()
        On Error Resume Next
        Application.ScreenUpdating = False
        Sheet9.ListObjects("filter_byDate").Range.AutoFilter field:=1, Criteria1:=">=" & Range("C4").Value, Operator:=xlFilterValues
        Application.ScreenUpdating = True
    End Sub

    In this code, “Sheet9” refers to the specific worksheet containing the data that requires searching based on dates. The code we have used employs the “greater than or equal” operator, indicating that any data with dates preceding the specified date will not appear in the output.
    I hope this answers your question. If you have any more queries, please please reach out to us.


    Thank you for reaching out. If I understand correctly, you are interested in creating a search box that can locate values from another worksheet and transfer them to the current worksheet. To accomplish this, you can use the following steps:
    Begin by creating a search box, and then add the following code to it.

    Private Sub TextBox1_Change()
        Application.ScreenUpdating = False
        Sheet6.ListObjects("DeclaringVariable_Data").Range.AutoFilter field:=2, Criteria1:=[c4] & "*", Operator:=xlFilterValues
        Sheet4.Range("F6").PasteSpecial Paste:=xlPasteAll
        Application.CutCopyMode = False
        Application.ScreenUpdating = True
    End Sub

    In this scenario, “Sheet4” is the worksheet containing the search box, and any copied values will be pasted into the range B6:D19 of this worksheet. Prior to pasting, the contents and formatting of the destination range will be cleared. “Sheet6” is the worksheet where the specified keyword will be searched for.
    With these steps completed, your search box is now ready for use.
    I hope this helps you to achieve your goal. If you need further assistance in this regard, please let us know.


  5. Hello AMIT,
    I appreciate your question. I’d like to clarify that in this article, the expression “Current Volatility” refers specifically to Implied Volatility, rather than Realised Volatility. When working with Option Probability, it’s generally more advantageous to use Implied Volatility rather than Realised Volatility since it enables us to make more precise predictions about the projected price range of a stock in the future.
    I hope this answers your question. If you have any more queries, please let us know.


  6. Dear UDAY KUMAR,

    Good afternoon! Thank you for reaching out to us. In the following section, I’ve suggested a method for handling your issue.
    First, apply this formula in cell M2.

    Formula Breakdown
    In this formula, item_name refers to the cell range H2:H5 of your provided worksheet, and max_issue represents the cell range I2:I5 of that worksheet.
    XLOOKUP(SEQUENCE(SUM(max_issue)),VSTACK(1,SCAN(1,max_issue,LAMBDA(a,b,a+b))),VSTACK(item_name,””),,-1)) → This part of the formula will generate the Item Names according to their maximum issue number.
    (H2:H5,I2:I5) → This part is required for specifying the cell ranges for item_name, and max_issue parameters of the formula.
    After applying this formula, you will get an output like this in your worksheet.
    Now, select these cells and copy them. Later, paste them as values in the same location.

    Now, apply the following formula in adjacent cell N2 and drag the Fill Handle up to cell N32.

    After that, select the data of Column M and Column N. Then, go to the Sort & Filter option from the Home tab and choose the Custom Sort option from the drop-down.

    A dialogue box named Sort will appear on your worksheet. In the Sort by field, select Column N. You can keep the other fields unchanged. Finally, click OK.

    Lastly, select the entire Column N and delete it.
    After following these steps, you will have a randomized list of Item Names for a month as demonstrated in the following image.

    I sincerely hope that this resolves the issue that you are facing. If you need any further assistance, please let us know. Have a great day!

    Zahid Hasan

  7. Dear Mohtasham,
    Thank you for your query. You wanted to extract a text value from a cell until a blank space appears in the text. It can be easily achieved by using a combination of LEFT function and FIND function in Excel. The formula is given below.
    =LEFT(B3,FIND(” “,B3,1))
    Here, we have our original text in cell B3. We applied this formula in cell C3.
    The FIND function will return the position of the first space in the text of cell B3. Then, the LEFT function will extract the texts up to that position from the left side of the text. You can drag the Fill Handle to copy down the formula for other cells as well. The following image demonstrates the formula and its associated outputs.

    I truly hope that this answers your question. Again thank you for reaching out to us. Please let us know in the comments area if there is anything about this approach that is unclear to you. I wish you all the best!

    Zahid Hasan

  8. Dear Uday Kumar,
    Good day! I can comprehend how upsetting this situation could be. It took me a while to understand it, too. Hence, the portion of your formula that I have highlighted in the following figure is essentially what is causing the issue when doing Conditional Formatting.

    It will display an error in the Conditional Formatting when you specify a range using both a cell reference and a formula. As the goal of this formula is to add up to the cell that comes before the active cell, you can use the following formula instead. Here I simply replaced INDEX(B$3:B3,ROWS(B$3:B3)-1) by B2. The complete formula is:
    =AND(SUM(B$3:B3)>B$35, IF(ROWS(B$3:B3)<>1, SUM(B2:B$3)<=B$35, TRUE))
    Just paste this formula in the Conditional Formatting option and you will have your desired output as shown below.

    That should take care of your problem, I hope. If you run into any problems, please let us know.

    Zahid Hasan

  9. Good day, Don Rogers.
    Thank you for your feedback. Could you please share your excel file with me so that I can better understand your problem and provide you with a solution? You can shareyour file to the email address provided below.
    [email protected]
    Thank you!

  10. Dear Uday Kumar,
    Good afternoon! First of all, thank you for the detailed description of the problem. What I have understood from your email, is that you want to highlight the cell where the sum of the distributed X items crosses the Previous Balance.
    Using the Excel formula in this situation becomes quite complicated and returns errors when used in the Conditional Formatting option. But running a simple Macro can achieve your desired output without any hassle.
    If you don’t know how to run a Macro, don’t worry. It’s not that complicated at all. Just follow the steps below, and you will be good to go.
    Step 01: Create a Blank Module
    At first, you will need to create a blank Module. The Module is where we will write the code. Simply press ALT + F11 on your keyboard to open the following window on your worksheet.
    creating new module
    Now, go to the Insert tab and choose the Module option from the drop-down list.

    Step 02: Write and Run VBA Code
    Now, a blank Module will be created.
    Then, copy the following code and paste it into the blank Module.

    Sub inventory_check()
    Set Rng = Selection
    Prev_bal = InputBox("Insert Previous Balance")
    Sum = 0
    Count = 0
    Rng.Cells.Interior.ColorIndex = xlNone
    For i = 1 To Rng.Rows.Count
        Sum = Sum + Rng.Cells(i, 1)
        If Sum > Int(Prev_bal) Then
            Rng.Cells(i, 1).Interior.Color = VBA.RGB(249, 176, 103)
            Count = Count + 1
                If Count > 0 Then
                    Exit Sub
                End If
        End If
    Next i
    End Sub

    After that, click on the Save icon.

    Following that, close the VBA window or simply press ALT + F11. This will take you back to your worksheet.
    Now, carefully select the range of data.
    Then, go to the Developer tab and click on the Macros option.

    Subsequently, the Macro dialogue box will open.
    Now, select the inventory_check option and click on Run.

    Then a window will appear asking you for the Previous Balance. You need to enter the previous balance here and then click OK.

    Boom! The highlighted cell will indicate your desired output.
    You can change the Previous Balance according to your need and the highlighted cell will be changed accordingly.

    Things to Remember
    If you don’t have the Developer option enabled then follow this article to enable it.
    Don’t forget to save the file as Macro Enabled Workbook.
    I sincerely hope that this solves the issue you are facing. If any part of the solution is unclear to you, please let us know.

    Zahid Hasan

Advanced Excel Exercises with Solutions PDF