Hello. i would like to bring back the last value from a column and subtract it with the first value of this column.
The thing is everyday i enter new data and my last column number always change, and the row numbers also grow up. the first value is always the same and never change.
So, i need a formula that can automatic keep the follow on my last value trough days/months.
Thanks for your times.
Let's say your values are in column A, try this...
=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))-A2
HTH
Regards, Jeff
Do you have a header row, so your data always starts in row 2?
Is your data always contiguous, or might you have gaps in it?
What column is your data in?
Pete
Thanks for help.
@Pete_UK My data are always in numbers but can be +750 and sometimes -150 or any number.
During last minutes i put more data in my sheet.
So I tell the good Cells for make it easier.(
B3 is my First value.
in column C i will write all new value day by day and might be endless.
Here what i try to do :
= Last value of C column - G2(witch is my first value) / by G2 + H2(Witch are the numbers of days depending if green or red)
Last edited by ImDavQc; 02-20-2021 at 11:57 PM.
the only thing i dont know to make it possible is the formula for always find my last value in column C.
Try...
=INDEX(C:C,MATCH(9.99999999999999E+307,C:C))-G2
Now to this, add the rest of what you need to calculate.
hello, thx for your help and time.
i tried your formula and it dont give me the correct result. it should give me around 329.
here the excel sheet.
In B Column only B3 Is Important.
In C column only the last number
C last column number - B3 / G2+H2
When i do this for the straight answer =((C40-B3)/G2+H2) it give me 612.91
if i use my computer calculator it give me 392.91. ;/
just take what Jeffery gave you and modify it based on what you wrote post #8 like...
=(INDEX(C:C,MATCH(9.99999999999999E+307,C:C))-B3)/(G2+H2)
that gives me a value of 361.89 which is also what I get with the calculator.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
ok ill do it. thanks for everyone help.
you're welcome AND thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks