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 ...
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.
So H13 is 600, and H25 is 708.
H51 is 250, H53 is 174 and H58 is 238.
Shouldn't H25 be 108?
You helped me so beautifully last time, I wondered if you might be able to please help again.
On this thread, you gave the formula for Column H to calculate the running difference in the values.
Now I would like a new Column "I" and a formula to return only the second value found for each grouping of rows, and otherwise return blank, essentially returning the second smallest number in each sequence and starting over for each new company.
So I25 would return 108
I43 would return 70
I53 would return 174
Thank you ahead of time!