Sajid Ahmed

About author

Sajid Ahmed, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, assumes the position of an Excel & VBA Content Developer at ExcelDemy. A self-motivated individual, his profound interest in research and innovation aligns seamlessly with his passion for Excel. In this role, Sajid not only adeptly addresses challenges but also demonstrates enthusiasm and expertise in gracefully navigating complex situations. This underscores his steadfast commitment to consistently delivering exceptional content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc. in Naval Architecture & Marine Engineering, BUET.

Expertise

Microsoft Suite, AutoCAD, Rhinoceros.

Experience

  • Technical Content Writing

Latest Posts From Sajid Ahmed

0
How to Use Bond Price Calculator in Excel? (A Complete Guide)

You can determine the present value of a bond with the bond price calculator in Excel. It helps you to assess the fair value of a bond and make correct ...

0
How to Use Excel Calculation Options (6 Suitable Examples)

In this article, you’ll learn 6 suitable examples of how to use Excel Calculation Options. The examples include changing the Calculation Options to ...

0
How to Export Excel to CSV?

In this article, you’ll learn how to export an Excel file to a CSV file using 4 methods. The methods include exporting only the active sheet using the Save As ...

0
COUNTIF Multiple Criteria (All Things You Need to Know)

In this article, you’ll learn how to use the COUNTIF function in Excel with multiple criteria in different scenarios with 4 suitable examples. The examples ...

0
Excel Formula List (40+ Useful Formulas to Master Excel)

In this Excel tutorial, you will get a list of useful Excel formulas for your daily use while working. We’ll use relevant practical datasets to give you a ...

1
How to Do GST Reconciliation in Excel (4 Methods)

  What Is GST Reconciliation in Excel? GST (Goods and Services Tax) is a tax applied to items you purchase or services you use. It’s added to the cost ...

0
How to Do Three Way Reconciliation in Excel: 5 Methods

Method 1 - Inserting Bank Statement and Transactions Record in Dataset Insert the bank statement for the month of July in a sheet titled “Inserting Bank ...

0
Excel VBA: How to Refresh All Data Connections – 4 Examples

This is an overview of Excel VBA tools used to refresh data connections. Create Data Connections between Excel Files The original dataset is ...

0
How to Calculate Running Total in Excel? (Complete Guide)

In this Excel tutorial, you'll learn -What is a running total -What are the uses of running total -How to calculate running total in Excel -And how to ...

0
How to Make a List in Excel (All Things You Need to Know)

In this Excel tutorial, you'll learn how to - Make a drop-down list in Excel (dependent, editable, and dynamic) - Input a message and error alert in the list ...

0
Excel SUMIF Not Working (9 Possible Cases with Solutions)

This image depicts 3 reasons and their solutions when the SUMIF function is not working among the 9 reasons we will discuss in this article. You can see the ...

1
How to Calculate Percentage of Total in Excel? (2 Methods)

Suppose you have a list of your daily or monthly transactions. You want to know in which transaction category you are spending the most. You can get this ...

0
How to Find Similar Text in Two Columns in Excel

In the following image, you see two columns having similar names. Column E shows which names are exactly the same and which are not. In this article, ...

0
How to Get 2 Decimal Places Without Rounding in Excel: 4 Methods

Method 1 - Getting 2 Decimal Places without Rounding for Both Positive and Negative Values in Excel  Using TRUNC Function Using Excel TRUNC function, we can ...

Browsing All Comments By: Sajid Ahmed
  1. Hello,
    Thanks for your comment.
    There was a small mistake in the formula. That’s why it is giving a Name error. The article and workbook are corrected and updated accordingly. If you have other queries let us know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  2. Hello,
    Thanks for your comment.
    The formulas are all right. They are working very nicely in our case. You have to insert the formulas carefully in the conditional formatting. Make sure you have put the cell references either absolute or relative correctly. Or if you can provide more information about your dataset then we could help.
    If you have other queries let us know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  3. Hello TOM,
    Thanks for your comment.

    Suppose, you have the following dataset with data in a single column in cells B5:B8. You want to add single quotes and separate them with a comma in cell B11. So, use the following formula with the CONCATENATE function in cell B11:

    =CONCATENATE(“‘”,B5,”‘”,”, “,”‘”,B6,”‘”,”, “,”‘”,B7,”‘”,”, “,”‘”,B8,”‘”)

    Using CONCATENATE function

    Press Enter to get the desired output.

    If you have other queries let me know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  4. Hello DRIN,
    Thanks for your comment.

    If you want to sum Notebook from India up to France and use drop-down for the countries, then use the following formula in cell C13:

    =SUM(INDEX($B$5:$G$8,MATCH(C10,$B$5:$B$8,0),MATCH(C11,$C$4:$G$4,0)+1):INDEX($B$5:$G$8,MATCH(C10,$B$5:$B$8,0),MATCH(C12,$C$4:$G$4,0)+1))

    It’ll give the desired result.

    SUM function

    Change the countries to China and Germany from the drop-down and the total value will be updated.

    SUM function 2

    If you have other queries let me know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  5. Hello ALEXANDER,
    Thanks for your comment.

    First, calculate the amortization schedule for the original loan. Then, calculate the amortization schedule for the additional loan separately. Now that you have the monthly payments for both loans, you can combine them to create a single amortization schedule. You’ll need to add the monthly payments together for each month and subtract this total from the outstanding balance.

    Repeat this process for each month until both loans are fully paid off. The combined amortization schedule will show the monthly payments and remaining balances as you pay off both loans simultaneously.

    If you have other queries let me know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  6. Hlw Jon S M,

    Thanks for your comment.
    If a customer has more than one invoice with different dates, you have to include multiple rows for that customer in the dataset. Each row will represent a separate invoice entry.
    The information related to that customer, such as their name, will be repeated in each row for their respective invoices. But the dates, invoice ids and invoice amounts will be different. The rest of the process is similar with this article.

    If you have other queries let me know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  7. Hello Hermione,
    Thanks for your comment.
    The “Run-time error ‘9’: Subscript out of range” error typically occurs when VBA code tries to reference a worksheet or object that doesn’t exist in the current workbook. In your case, the error is likely occurring because there is no worksheet named “all books” in your Excel workbook.

    To fix this issue, you need to ensure that the worksheet name you’re trying to reference (“all books”) exactly matches the name of a worksheet in your workbook. If the worksheet name is different or contains typos or extra spaces, you will encounter this error.

    If you have other queries let me know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  8. Hlw Terrisa,
    Thank you very much for your comment. The right formula for your need is given below-

    =IFERROR(MIN((DATEDIF(W6,TODAY(),”d”)+1)/(DATEDIF(W6,X6,”d”)+1), 1), 0)

    Here, we add the MIN function to cap the calculated percentage to 100%. If the calculated percentage is greater than 100%, this function will return 100%, capping the percentage. If the calculated percentage is less than or equal to 100%, it will return the calculated percentage as it is.

    If you have other queries let me know in the comment.
    Regards,
    Sajid Ahmed
    Exceldemy

  9. Thank you very much for your valuable comment. You are right. The ASCII character 160 is different than character 32. If you have any cell containing the ASCII character 160 non-breaking space then the TRIM function described in method 1 won’t work.
    However, you can use the combination of the SUBSTITUTE and CHAR functions then. Suppose you have a value in cell A1 of your dataset containing the ASCII character 160 non-breaking space. Then you can use the following formula to remove unwanted spaces-

    =SUBSTITUTE(A1,CHAR(160), “”)

    After using this formula you can apply the Remove Duplicates button.

    Regards
    Sajid Ahmed
    ExcelDemy

  10. Hello Ayodeji Aboderin, thanks for reaching out. You are right, there was an error. Now, the article is updated accordingly. Please let us know if you have any other queries.
    Regards
    Sajid Ahmed
    Exceldemy

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo