Nazmul Hossain Shovon

About author

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

Latest Posts From Nazmul Hossain Shovon

0
How to Use If Then Else Statement in Excel VBA (4 Examples)

In this tutorial, I am going to share with you 4 practical examples to use the If Then Else statement in Excel. You can easily apply these examples in any set ...

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

In this tutorial, I am going to share with you 3 quick tricks to find the max date in a range with criteria in Excel. You can easily apply these examples in ...

0
How to Apply Conditional Formatting Using Checkbox in Excel

In this tutorial, I am going to share with you 3 practical examples of how to apply conditional formatting using a checkbox in Excel. You can easily apply ...

0
How to Use VBA Evaluate Function in Excel (4 Practical Examples)

In this tutorial, I am going to share with you 4 practical examples of how to use the VBA Evaluate function in Excel. You can easily apply these examples in ...

0
How to Use DSTDEV Function in Excel (3 Practical Examples)

In this tutorial, I am going to show you 3 practical examples of how to use the DSTDEV function in Excel. Specifically, you can quickly use these methods to ...

0
How to Find Standard Error of Estimate in Excel (3 Easy Ways)

In this tutorial, I am going to show you 3 easy methods of how to find the standard error of estimate in Excel. You can quickly use these methods to find the ...

0
List of Dynamic Array Formulas in Excel (7 Practical Examples)

In this tutorial, I am going to share with you 7 practical list of dynamic array formulas in Excel. You can easily apply these functions to perform a wide ...

0
How to Find Distance Between Zip Codes in Excel Using Formula

In this tutorial, I am going to show you 2 easy methods of how to find the distance between zip codes in Excel using a formula. You can quickly use these ...

0
How to Perform Page Scaling in Excel (4 Quick Tricks)

In this tutorial, I am going to show you 4 quick tricks on how to perform page scaling in Excel. You can quickly use these methods, especially in large ...

0
How to Make Cost Estimation Sheet in Excel (with Easy Steps)

In this tutorial, I am going to show you the step-by-step procedures to make a cost estimation sheet in Excel. You can quickly use these methods, even with ...

0
Excel Join Formula (8 Practical Examples)

In this tutorial, I am going to show you 8 practical examples of using the Excel join formula. You can quickly use these methods even in large datasets to join ...

0
How to Insert WordArt in Excel (2 Simple Methods)

In this tutorial, I am going to share with you 2 simple methods to insert WordArt in Excel. You can easily apply these methods in any set of data to add both ...

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

In this tutorial, I am going to show you step-by-step procedures on how to create a leaderboard in Excel. You can use these steps for any type of dataset to ...

0
Compatibility Function in Excel (34 Practical Examples)

In this tutorial, I am going to share with you 34 practical examples of compatibility function in Excel. You can easily apply these functions to perform a wide ...

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

In this tutorial, I am going to share with you 4 quick tricks to put a circle around a number in Excel. You can easily apply these methods in any set of data ...

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