=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,
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 intoI12. =IF(ISBLANK(B12),"",I11-F12+G12) HitEnterand usethe AutoFill featureto fill the remaining cells. Formula Breakdo...