=UNIQUE(B4:B12) This is the output. Example 2 – Use the FILTER Function to Create an Array Formula in Excel Extract the data for Katy: Enter the formula inB15: =FILTER(B5:D13,B5:B13="Katy") B4:D12is the range, andB4:B12=”Katy” is the criterion for filtering. PressENTER. Thi...
Step 8 – Replicate Formulas for Later Rows Up until now, we’ve only created formulas in the first row. We need to replicate these formulas for subsequent rows. Select cellB12and enter the following formula: =IFERROR(IF(G11>1,B11+1,""),"") Breakdown of the Formula IFERROR(IF(G11...
For the first row, copy the value from Starting Balance and leave the other values empty. Step 6 – Insert Formula in the Balance Column Insert the following formula into I12. =IF(ISBLANK(B12),"",I11-F12+G12) Hit Enter and use the AutoFill feature to fill the remaining cells. Formula...
Let’s assume we have an Excel worksheet that contains the information about the EMI calculation with the prepayment option. We will calculate the EMI with the prepayment option from our dataset using Excel’s PMT andIPMTfinancial formulas.PMTstands forpayment, andIPMTis used to get theinterest ...