Hello,
I have searched everywhere and I can't figure out how to create a formula for the following situation.
I have a series of values (or blank due to a new time not being achieved) in C2-K2. I need cell M2 to be the difference between the most recent cell with a value in C2 - K2 (C2-K2 are months in a year with their correlating times) and L2. L2 is a static value that I need to know how close we are to achieving that number (M2).
I hope this is understandable and thank you all very much in advance for any help you can give.
If I can clarify, please let me know.
L
I have searched everywhere and I can't figure out how to create a formula for the following situation.
I have a series of values (or blank due to a new time not being achieved) in C2-K2. I need cell M2 to be the difference between the most recent cell with a value in C2 - K2 (C2-K2 are months in a year with their correlating times) and L2. L2 is a static value that I need to know how close we are to achieving that number (M2).
I hope this is understandable and thank you all very much in advance for any help you can give.
If I can clarify, please let me know.
L