User Posts: Mursalin
0
How to Automatically Hide Rows with Zero Values in Excel
0

In this article, we will learn to automatically hide rows with zero values in Excel. In Microsoft Excel, we store different types of data and use them ...

0
How to Create a Table with Existing Data in Excel
0

In this article, we will learn to create a table with existing data in Excel. The Table is one of the most powerful features of Excel. It helps the users to ...

0
How to Insert Sheet from Another File in Excel (3 Easy Ways)
0

In this article, we will learn to insert a sheet from another file in Excel. Excel users often need to insert files from another file. Sometimes, we insert a ...

0
How to Calculate Monthly Payment on a Loan in Excel (2 Ways)
0

In this article, we will learn to calculate the monthly payment on a loan in Excel. When you take a loan for a certain period, you need to make a monthly ...

0
How to Change Conditional Formatting Icon Set Color in Excel
0

In this article, we will learn to change the conditional formatting icon set color in Excel. Unfortunately, you can’t change the conditional formatting icon ...

0
How to Do Repeated Measures ANOVA in Excel (With Easy Steps)
0

In this article, we will do repeated measures ANOVA in Excel. Microsoft Excel is a powerful tool and makes complicated calculations easy. We can perform ...

0
How to Repeat Rows at Top of Specific Pages in Excel
0

In this article, we will learn to Repeat Rows at Top of Specific Pages in Excel. Microsoft Excel provides users with the opportunity to enlist large datasets. ...

0
How to Calculate Annual Debt Service in Excel (3 Ideal Examples)
0

In Microsoft Excel, users can perform various operations and find the value of different quantities. Today, we will learn to calculate annual debt service in ...

0
Create Cash Flow Statement Format Using Direct Method in Excel
0

In this article, we will learn to create a cash flow statement format using the direct method in Excel. A cash flow statement is prepared to enlist the ...

0
How to Calculate Future Value of Growing Annuity in Excel
0

In this article, we will learn to calculate the future value of a growing annuity in Excel. In Excel, users can solve different problems using different Excel ...

0
How to Make Legend Markers Bigger in Excel (3 Easy Ways)
0

In this article, we will learn to make legend markers bigger in Excel. Legend markers are used to denote the data with specific colors. Sometimes, legend ...

0
How to Hide Chart Data in Excel (With Quick Steps)
0

In this article, we will learn to hide chart data in Excel. Sometimes, we need to protect data or show less information on the chart. In that case, we can hide ...

0
How to Hide Blank Cells in Excel (5 Easy Ways)
0

In this article, we will learn to hide blank cells in Excel. Unfortunately, you can’t hide an individual blank cell in Excel. You will have to hide the whole ...

0
Excel VBA to Hide Columns Using Column Number (6 Examples)
0

This article will teach us to hide columns using the column number with VBA in Excel. Usually, excel expresses columns with alphabets. But we can also ...

0
How to Limit Columns in Excel (3 Quick Ways)
0

In this article, we will learn to limit columns in Excel. Sometimes, users need to work on specific columns. In that case, one needs to limit columns. Today, ...

Browsing All Comments By: Mursalin
  1. Hello, Abu!
    Thanks for your comment. Unfortunately, it is not possible to show the expected end date dynamically after each pre-payment. Because the dataset changes dynamically after a pre-payment. But you can find the expected payment date after each month using the formula below. For the dataset, we have used in this article, you can type the formula in Cell H8:
    =DATE(YEAR(H7),MONTH(H7)+(12/$J$15),DAY(H7))
    Here, Cell H7 contains the loan starting date and Cell J15 contains the number of yearly payments.
    You can also take a look at this article https://www.exceldemy.com/student-loan-payoff-calculator-with-amortization-table-excel/ for an explanation of the formula. I hope this will help you to solve your problem.
    Thanks!

  2. Hello, Dom!
    Thanks for your feedback. If you are facing any problems generating code 128 barcode font in Excel, then you can ask here. We will try to reply to you as soon as possible.
    Thanks!

  3. Hello, Bimen!
    Sorry to hear that you are facing problems converting minutes to decimal numbers. You can send your excel file to [email protected] and we will try to give a solution to your problem.
    Thanks!

  4. Hi BIPLAB,
    Thanks for your query. You can build a formula with the nested CONCAT function. In that case, you don’t need any helper column. For the dataset we have discussed in the article, the formula will be:
    =CONCAT(CONCAT(B5,” “,C5,” “,D5),”,”, CONCAT(B6,” “,C6,” “,D6),”,”,CONCAT(B7,” “,C7,” “,D7),”,”,CONCAT(B8,” “,C8,” “,D8))
    You can also use the VBA code below. To apply this, you need to select the rows of the first column of the dataset and then run the code from the Macro window.

    Sub Merge_Rows_with_Comma()

    Dim iSelection As Range
    Dim iRow As Range
    Dim iCell As Range
    Dim iStr As String

    Application.ScreenUpdating = False
    On Error Resume Next
    Set iSelection = Intersect(Selection, ActiveSheet.UsedRange)

    For Each iRow In iSelection.Rows
    For Each iCell In iRow.Cells
    iStr = iStr & ” ” & VBA.Trim$(iCell)
    Next iCell
    iRow.ClearContents
    iRow.Cells(1, 1).NumberFormat = “@”
    iRow.Cells(1, 1) = Mid(iStr, 2)
    iStr = vbNullString
    Next iRow

    For Each iCell In iSelection
    iStr = iStr & “,” & VBA.Trim$(iCell)
    Next

    With ActiveWindow
    .Selection.ClearContents
    .Selection(1, 1).NumberFormat = “@”
    .Selection(1, 1).Value = Mid(iStr, 2)
    End With
    End Sub

ExcelDemy
Logo