Hi!
I will have excel to calculate the percent change between to values where an improvement is always shown as a positive value and a decline is always shown as a negative value. My problem is that I want excel to calculate this between the to latest values only i.e. if column J is blank, calculate with column I and H etc. also if a player misses a test and column J is blank but so is column H, then it would be really nice if excel could use the data from I and G.
I have absolutely no idea how to write a dynamic formula like this. I am familiar with IF formulas but I couldn't find a way for that to work :/
Anyone able to help me? I attached a simple workbook with some numbers to calculate on.
Thanks!
Markus
Bookmarks