Say there is a value in cell E1, which has been calculated from the contents of cells in column D. With Goal Seek one can alter the number at E1 by changing one of the cells in column D.
Rather than altering a single cell in that column, should I need to more than one to obtain the required value at E1, is there a way I can do that?
Rather than altering a single cell in that column, should I need to more than one to obtain the required value at E1, is there a way I can do that?