Hello guys,
I have a number of equations containing range names in a massive excel spread sheet that would take days to alter manually as the regular autofill function does not seem to work for this.
Here an example:
=(cost_1*component_demand_1+failure_1*cost_1+failure_1*installation_cost_1)/number_of_operators
I would like the cell below this one to read:
=(cost_2*component_demand_2+failure_2*cost_2+failure_2*installation_cost_1)/number_of_operators
This should continue down the entire column and finish with:
=(cost_100*component_demand_100+failure_100*cost_100+failure_100*installation_cost_100)/number_of_operators
I have about 20 such equations that need to be altered so it would take me countless hours to do manually. Is there a way of automating this process?
Thanks in advance!
Ian
I have a number of equations containing range names in a massive excel spread sheet that would take days to alter manually as the regular autofill function does not seem to work for this.
Here an example:
=(cost_1*component_demand_1+failure_1*cost_1+failure_1*installation_cost_1)/number_of_operators
I would like the cell below this one to read:
=(cost_2*component_demand_2+failure_2*cost_2+failure_2*installation_cost_1)/number_of_operators
This should continue down the entire column and finish with:
=(cost_100*component_demand_100+failure_100*cost_100+failure_100*installation_cost_100)/number_of_operators
I have about 20 such equations that need to be altered so it would take me countless hours to do manually. Is there a way of automating this process?
Thanks in advance!
Ian