Forum Discussion
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 ...
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.
- 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.Shouldn't H25 be 108?
