I have a column with 23 cells. (One for each workday) Each day I will enter data that will give a result in that column.
For example F3 to F25. I will enter data in C3 and a result will appear in F3. Then data in C4, result in F4, etc.
I want the result in the F column to appear also in F27 with F27 changing to the new result each time I enter data in the C column.
If I enter data in C5 the result will appear in F5 and F27. When I enter data in C6 the result will appear in F6 but I want it
also in F27 instead of the F5 data. I have different formulas, with different results, that I want to display in the same cell. Each new
result takes priority over the previous result. Each new result could be higher or lower than the previous result. How do I do it?
I hope that makes sense.
For example F3 to F25. I will enter data in C3 and a result will appear in F3. Then data in C4, result in F4, etc.
I want the result in the F column to appear also in F27 with F27 changing to the new result each time I enter data in the C column.
If I enter data in C5 the result will appear in F5 and F27. When I enter data in C6 the result will appear in F6 but I want it
also in F27 instead of the F5 data. I have different formulas, with different results, that I want to display in the same cell. Each new
result takes priority over the previous result. Each new result could be higher or lower than the previous result. How do I do it?
I hope that makes sense.