Forum Discussion
Formula Help
Hello All, I am trying to come up with a differential formula to let me know how I am doing on a month to month basis. So for example in Jan I earned 2,000 and then in Feb. I earned 2,600. In...
I agree with Damien's suggestion but if you insist, then this should be your formula in C19:
=INDEX(C5:C16,COUNT(C5:C16))-
INDEX(C5:C16,COUNT(C5:C16)-1)
=INDEX(C5:C16,COUNT(C5:C16))-
INDEX(C5:C16,COUNT(C5:C16)-1)
So one more question for you guys if you don't mind... using the same table as above but this time instead of subtracting C6-C5 and C7-C6. How would I make a formula to subtract each month only from January. So C6-C5, then C7-C5, then C8-C5 and so on?
thank you for your time and help
You may use C$5 instead of C5 in first approach and
=INDEX(C5:C16,COUNT(C5:C16))-C5
in second one
- Thank You Sergei! I really appreciate your time and help!
