Forum Discussion
Forumula Help
Hi guys Is there anyway to make a number/text from a table not change? For example I have the following table below and a formula in cell C4 showing =A1(10). Is there anyway to make C4 show 1...
Why you not simply write the number 10 in cell C4 or cell $C$4 or cell C$4?
Hi Bob
I need it to automate. For example my rep count for Pull ups is 9 as per below. What I want to do is mark off the date completed section to show I have completed that exercise. From there the data will and pull through onto a table.
In two weeks (based on my formula) my Rep count could change which would effect all the 2 weeks data because the table will change to the new rep count.
Sorry very confusing but I hope it makes sense. I need the data to automate but not change if my rep count changes. It will save me creating a new Workout template every time the rep count changes.