Md. Nafis Soumik

About author

Md. Nafis Soumik graduated from Bangladesh University of Engineering & Technology, Dhaka, with a BSc.Engg in Naval Architecture & Marine Engineering. In January 2023, he joined Softeko as an Excel and VBA content developer, contributing 50+ articles on topics including Data Analysis, Visualization, Pivot Tables, Power Query, and VBA. Soumik participated in 2 specialized training programs on VBA and Chart & Dashboard designing in Excel. During leisure, he enjoys music, travel, and science documentaries, reflecting a diverse range of interests.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education in Naval Architecture & Marine Engineering, Bangladesh University of Engineering & Technology


Content writing, VBA, C++, Python, MATLAB, MS Office, AutoCAD.


  • Industrial Training in Khulna Shipyard Limited
  • Technical Content Writing
  • Undergraduate Project
    • Design of an 87m long Offshore Supply Vessel (OSV)
  • Undergraduate Thesis
    • A Comparative Linear Buckling Analysis of Different Isotropic Plates with and without Stiffeners for Different Boundary Conditions.


  • Currently working as an Excel & VBA Content Developer.
  • Started technical content writing of Excel & VBA in January 2023.

Latest Posts From Md. Nafis Soumik

Hierarchy in Excel (Create, Customize, Features)

In this article, we are going to learn about hierarchy in Excel. We shall use the SmartArt feature to create and customize a hierarchical structure such as an ...

Excel Interpolation (Linear & Non-linear Interpolation)

We can use interpolation in financial analysis to estimate missing values. In engineering, estimation of variables like temperature or pressure can also be ...

Frequency Distribution in Excel (4 Suitable Methods)

Frequency distribution in Excel refers to a tabular representation that shows the number of occurrences of each value or range of values in a dataset. In ...

Copy Sheet in Excel (Copy in Same or Different Workbook)

In this article, you are going to learn various methods including VBA to copy sheet in Excel. You will learn to copy a single worksheet or multiple worksheets ...

How to Apply Abbreviation in Excel (Abbreviate Words, Numbers)

In this Excel tutorial, you will learn how to, - Create an abbreviation for names or words using an initialism approach, where only the first word in a group ...

How to Compare in Excel? (10 Practical Examples)

Compare in Excel means comparing two or multiple cells, columns, worksheets, or workbooks in Excel to find out matches and differences. In this free Excel ...

Excel Conditional Formatting with Named Range (3 Examples)

In this article, you will learn to use Excel conditional formatting with named range. You will see the use of named range in conditional formatting array ...

Excel VBA to Wrap Text (3 Practical Examples)

Excel VBA provides various methods to wrap text in cells, ranges, and entire worksheets. Knowing these methods can help you customize the appearance of your ...

How to Make an Availability Schedule in Excel (with Easy Steps)

You can find a number of ready-to-use templates online, but creating a customized template that fits your needs can be even more beneficial. You can customize ...

How to Use Target Value in Excel VBA

One of the most powerful features in Excel VBA is the ability to use Target.Value method, which allows users to monitor changes made to their spreadsheet and ...

How to Create Half Doughnut Chart in Excel (with Easy Steps)

A half-doughnut chart is a type of chart that displays data in a half-circle shape with a hole in the center. It is a useful tool for presenting data in a ...

How to Merge Cells in Excel Without Merging Actually

One of the most commonly used features in Excel is merging cells, which allows you to combine multiple cells into a single, larger cell. While this can be ...

How to Create Multiple Folders at Once from Excel

Are you tired of manually creating multiple folders on your computer? Do you have a long list of folder names in an Excel sheet that you want to create at ...

Excel VBA: How to Exit a For Loop (5 Examples)

Excel VBA is a powerful tool that can automate tasks and make complex calculations in Microsoft Excel. One of the essential features of VBA is the ability to ...

How to Find and Replace Text Color in Excel (3 Quick Ways)

Certainly, finding and replacing text color in Excel is a common task that we have to perform in order to organize, highlight, and present data in a clear and ...

Browsing All Comments By: Md. Nafis Soumik
  1. Hi Kevin!
    It brings me great joy to know that you found our blog helpful. You are most welcome. As for your query, you can use the following formula: =INDEX(D4:D12,MATCH(1,(F4=B4:B12)*(G4=C4:C12),0))
    To be more clear about the cell references look at the image below:
    Multiple Criteria  Lookup


  2. Hi MAHMUD,

    Thank you for your valuable suggestion. I updated the formula for calculating electricity bill with Variable Unit Price (Slab). Hope you find this article useful.


  3. Hi Liam,
    Thank you for taking the time to comment on our blog and for suggesting a shorter method for the task that is demonstrated. We appreciate your input and always welcome new ideas.

    After carefully considering your formula, I noticed there was a backslash “\” missing from the col_delimiter argument of the TEXTSPLIT() function inside the formula. To ensure the best results, modify your formula like this: =CHOOSECOLS(TEXTSPLIT(A1,"\"),-1) (Assuming the full path address is inside the cell A1).

    We value your engagement and encourage you to keep sharing your thoughts and ideas. It’s through constructive discussions like this that we can all learn and improve. Thanks again for your comment!

  4. Reply Nafis Soumik
    Md. Nafis Soumik Oct 3, 2023 at 9:22 AM

    Hi Mahmoud,
    You can create a half doughnut chart to show the correct percentages with data labels by following the steps mentioned in this article. Only exception is you will need a different data table with the yearly revenues converted into percentages of the total.
    You can do this by applying the following formula inside any cell: =C5/$C$10. Use fill handle to populate the dataset and keep the percentage column into percentage format. Now follow the exact steps described in this article. Upon finishing check the Data Labels option from Chart Element. Your half doughnut chart with percentage Data labels is now ready.
    Half Doughnut Chart Showing Actual Percentages
    I hope it solves your problem.


  5. Hello JK,

    Which formula are you talking about?
    Do you have a formula for yourself that you want to convert?
    Or, Do you want to convert any of the formulas from the post?

    Please let us know. We would be happy to help.


  6. Hi Jenn,
    Based on your comment, it seems you are looking for a way to create a spreadsheet that displays different tables based on the selected company.
    To address your requirement, one approach is to use Excel’s “Data Validation” feature combined with “Index” and “Offset” functions. Here’s a potential step-by-step solution:
    1. Set up your spreadsheet with separate tables for each company, each in a different range of cells.
    2. Create a list of company names (e.g., in a dropdown) where the user can select the desired company.
    3. Assign data validation to the cell where the user selects the company, limiting the input to the list of company names.
    4. Next, use the “Index” and “Offset” functions to display the corresponding table based on the selected company.

    Here’s an example of how this could work:
    1. Create separate tables for each company, each in a different range of cells (e.g., Company A in cells A1:D10, Company B in cells A15:D24, Company C in cells A29:D38).
    2. Create a dropdown list of company names (e.g., in cell A50) using Excel’s Data Validation feature.
    3. Use the “Index” and “Offset” functions to retrieve the appropriate table based on the selected company. For example, in cell A55, you could use the following formula:
    =INDEX($A$1:$D$10, OFFSET($A$1:$A$10, MATCH($A$50,$A$1:$A$10,0)-1, 0, ROWS($A$1:$A$10), COLUMNS($A$1:$D$10)))
    This formula will retrieve the table for the selected company dynamically.
    Now, when you select a company from the dropdown list in cell A50, the corresponding table will be displayed in cell A55 and automatically update based on the selection.
    Please note that the specific ranges and formulas may need to be adjusted based on the actual structure and layout of the spreadsheet. However, this approach should provide a starting point to achieve the desired functionality of displaying different tables based on the selected company in Excel.


  7. Reply Nafis Soumik
    Md. Nafis Soumik Jul 2, 2023 at 2:06 PM

    Hello Kumar,
    Both the formulas you mentioned work fine and generate same results. Try again. If it still does not work, please send us your Excel file at [email protected]
    And yes. There is a simpler formula to find out the original price directly without calculating the GST amount. Use this formula inside cell C7: Original price = C4/(1+C5)

    Thank you.

  8. Hello Ed McCann,
    It’s possible that the Pivot table is referencing a range of cells that includes data outside of the intended range. Here are a few steps you can try to troubleshoot the issue:

    1. Check the source data range: Make sure that the Pivot table is referencing the correct range of cells that contain your data. Select any cell inside the Pivot table, go to the “Analyze” or “Options” tab in the ribbon, and look for the “Change Data Source” or “Select Data” button. Clicking on this button will show you the range of cells that the Pivot table is using as its data source.

    2. Check for hidden data: It’s possible that there is hidden data in the source data range that is being included in the Pivot table. Select the source data range, go to the “Home” tab in the ribbon, and click on the “Format” dropdown. From here, click on “Hide & Unhide” and then “Unhide Rows/Columns” to reveal any hidden data.

    3. Refresh the Pivot table: If none of the above steps work, try refreshing the Pivot table. Select any cell inside the Pivot table, go to the “Analyze” or “Options” tab in the ribbon, and click on the “Refresh” button. This will recalculate the Pivot table based on the current data source.

    I hope these steps help you troubleshoot the issue with your Pivot table.

    If the problem persists, then you can send your excel workbook to this email: [email protected]


Advanced Excel Exercises with Solutions PDF