Forum Discussion

BrittD2's avatar
BrittD2
Copper Contributor
Feb 16, 2021

Formula to Calculate Difference in Value After Finding First Non Blank Cell

Hello all,   I need help with a formula and the subsequent calculation. Please see the attached workbook. This is a sample work book illustrating my dilemma.    Column B is the date of purchase ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Feb 16, 2021

BrittD2 

Assuming that you have Excel in Office 2019 or Microsoft 365, enter the following array formula in H2, comfirmed with Ctrl+Shift+Enter:

 

=IF(G2=1,TEXTJOIN(", ",TRUE,IF($C$2:$C2=$C2,$E$2:$E2,"")),"")

 

Fill down.

BrittD2's avatar
BrittD2
Copper Contributor
Feb 16, 2021
Hans, thank you. I should've been more clear. I only want one single value per cell.
So H13 is 600, and H25 is 708.
H51 is 250, H53 is 174 and H58 is 238.
    • BrittD2's avatar
      BrittD2
      Copper Contributor
      Feb 16, 2021

      HansVogelaar 

       

      Yes, of course, thank you!

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Feb 16, 2021

        BrittD2 

        In H2:

         

        =IF(G2=1,E2-MAXIFS($E$1:$E1,$C$1:$C1,$C2),"")

         

        Fill down.

Resources