With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have attached a spread sheet that I would like to automatically change numbers in the Result Columns when changed in the SET section.
As an example the # 1 is the first number in Set1. It is used in Results Columns 1-10. If I were to change that 1 to the number 67 then each instance where the # 1 is used would need to be changed to the # 67.
Assuming we start out with Nulls, for all number sets, then the spread sheet would need to start assigning that number to each grouping based in the Include Set information.
I don't know if starting out with Null Values is the best way to do this but we must consider that each SET of numbers can include a MAX of 3 numbers per set.
Since Set 1 only has 2 numbers assigned to it I would think that if we used a zero (0) that would then make (Result Value for the first row look like 1-2-0-10-20-3-4-72. Zero is not applicable to this application and would only confuse the results.
The Null value would have to be truncated to make the results ...
Sign in or Register to see more