Nazmul Hossain Shovon

About author

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his chosen field.

Designation

Junior Software Developer at SOFTEKO

Lives in

Dhaka, Bangladesh.

Education

BSc in Naval Architecture and Marine Engineering from BUET.

Expertise

JavaScript, React, Nodejs

Experience

  • Software Developer
  • Content Writer

Summary

  • Currently working as Junior Software Developer in Web Technologies in Software Development Team.
  • Started technical content writing of Excel & VBA in June 2022 and later joined the software development team after 8 months.

Latest Posts From Nazmul Hossain Shovon

0
How to Find Max Date in Range with Criteria in Excel

The dataset we'll use for this tutorial has nine rows and three columns. Initially, we'll keep all the cells in General format and the date values in Date ...

0
How to Find the Distance Between Zip Codes Using a Formula in Excel – 2 Easy Methods

The sample dataset has 2 types of columns (Location 1 and Location 2). Method 1 - Using a Geometric Formula to Find the Distance Between Zip Codes ...

0
How to Create a Cost Estimation Sheet in Excel

Step 1 - Prepare Your Dataset: Begin with a concise dataset containing approximately 11 rows and 6 columns. Keep all cells in the General format, and ...

0
How to Create a Leaderboard in Excel (with Easy Steps)

The procedures to create a leaderboard in Excel in this tutorial can also be used to create any type of dataset to rank a list of data. Step 1 - Making a Base ...

0
How to Put a Circle Around a Number in Excel (4 Quick Tricks)

In the dataset below, we have 3 columns showing Product ID, Product Name, and Sales (units). Method 1 – Using Excel Illustrations Feature to Put a ...

0
How to Add Text to Textbox Using Excel VBA (3 Effective Ways)

In this tutorial, I am going to share with you 3 effective ways to add text to a Textbox using Excel VBA. You can easily apply these methods in any set of data ...

0
How to Convert Text Box to Cell in Excel (with Easy Steps)

In this tutorial, I am going to show you the step-by-step procedures on how to convert a text box to a cell in Excel. You can use these steps for any type of ...

0
How to Make a Payroll System with Payslip in Microsoft Excel  – 4 Steps

  The sample dataset has 6 rows and 8 columns. Cells with monetary values are in Accounting format. Step 1 - Creating a Dataset Enter the ...

0
How to Use COUNTIF Function In Excel to Count Bold Cells

In this tutorial, I am going to share with you step-by-step methods on how to use the COUNTIF function to count bold cells in Excel. You can easily apply these ...

0
[Fixed!] Excel Filter Stops at Blank Row (4 Possible Solutions)

In this tutorial, I am going to show you 4 possible solutions to Excel filter stops at blank rows. You can use these fixes in your own dataset to find blank ...

0
How to Use SUBTOTAL COUNTA Function in  Excel: 5 Suitable Examples

Keep all the cells in General format. For all the datasets, we have 2 unique columns which are Items and Sales (units). We may vary the number of columns later ...

0
How to Copy the Same Date in Excel (6 Simple Methods)

Method 1 – Using a Fill Handle Steps: Go to the lower-right corner of cell C5 and drag the + symbol down using the mouse. Click on the Auto Fill ...

0
How to Convert XML to Columns In Excel (4 Suitable Ways)

In this tutorial, I am going to show you 4 suitable ways to convert XML to columns in Excel. You can use these methods even in large datasets to find out the ...

0
How to Make a Restaurant Cash Flow Statement in Excel

In this tutorial, I am going to show you step-by-step procedures to make a restaurant cash flow statement in Excel. You can use these steps even in large ...

0
How to Calculate Billable Hours in Excel (4 Effective Ways)

In this tutorial, I am going to show you 4 effective ways to calculate billable hours in Excel. You can use these methods even in large datasets to find out ...

Browsing All Comments By: Nazmul Hossain Shovon
  1. Reply Avatar photo
    Nazmul Hossain Shovon Dec 4, 2022 at 3:14 PM

    Hi Shruti,
    I have attached an Excel file that you can use to find specific absent dates. Hope it helps!
    Download link

  2. Reply Avatar photo
    Nazmul Hossain Shovon Dec 4, 2022 at 2:23 PM

    Hi Maikel,
    Can you share your Excel file with us, kindly? So that we may have a look at it and give you some suggestions.

  3. Reply Avatar photo
    Nazmul Hossain Shovon Dec 4, 2022 at 12:24 PM

    Hi Cory,
    You can follow the steps below for this:
    1. Fill up the information in the pdf file. Then go to File >> Save as Text. This will create a file in .txt format.
    2. Now open an Excel sheet. Go to the Data tab. Here in the top left corner, click on From Text/CSV and select the text file you just saved.
    3. Finally in the next window, click on Load and this should bring the filled-in information as well.
    Hope this helps!

  4. Reply Avatar photo
    Nazmul Hossain Shovon Nov 14, 2022 at 11:03 AM

    Hi Mike,
    You can try the following steps to change the date format in excel comments:
    1) Type intl.cpl in the Windows Search Box.
    2) Now, under Date and time formats, click on the Short date drop-down and choose the date format that you want to use in the comments in excel.

  5. Reply Avatar photo
    Nazmul Hossain Shovon Nov 14, 2022 at 10:59 AM

    Hi James,
    Thanks for your correction. To add, you can also calculate the GST amount using this formula:
    GST Amount = (C4*C5)/(1+C5)
    Then we can deduct this value of cell C6 from C4 to get the original price in cell C7.

  6. Reply Avatar photo
    Nazmul Hossain Shovon Oct 24, 2022 at 3:39 PM

    Hi Brijesh,
    I have created a simplified solution below. Please follow them:
    1. I am assuming that you have a Sheet1 like below:
    starting dataset
    2. Now, go to the Sheet2 and insert the following formula in cell C5:
    =IFERROR(VLOOKUP(Sheet1!$B$5,B5:B12,1,FALSE),"Not Found")
    formula
    3. Now, simply copy this formula down using Fill Handle and this should tell you whether the product in cell B5 inside Sheet1 exists in the Product List column or not.
    final result

  7. Reply Avatar photo
    Nazmul Hossain Shovon Oct 24, 2022 at 11:43 AM

    Hi KARLHEINZ,
    Looks like you have missed the <> symbol in the SMALL(IF((LEN($H$6:$H$13)0) portion of the formula. The correct formula should be this:
    SMALL(IF((LEN($H$6:$H$13)<>0)
    I hope this solves your problem. Please let us know if you face any other issues.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo