Forum Discussion
Varying Assigned Values
I have tried to figure out what you are trying to do and have created a sample file. I hope this is a first start to solve your problem.
You can overwrite the values in Sheet1 column D with a value. The other values of the same section will be recalculated.
You can delete the columns J, K, and L of Sheet1. The values are calculated again in Sheet2.
Give me some feedback if you were able to do something with this.
I have tried to figure out what you are trying to do and have created a sample file. I hope this is a first start to solve your problem.
You can overwrite the values in Sheet1 column D with a value. The other values of the same section will be recalculated.
You can delete the columns J, K, and L of Sheet1. The values are calculated again in Sheet2.
Give me some feedback if you were able to do something with this.
Section 1 has 5 questions
Section 2 has 5 questions
Section 3 has 4 questions
Section 4 has 5 questions
Section 5 has 3 questions
Have you been able to review my prior post with my sample table?