Data in Excel at EFGHIJKLMNOPQ... Column, now want to empty a line after the last column data, then the difference between calculated (such as: S column value equals F column value minus the value of the column E, T column value equals the value of the G column minus E column values, that is to say, respectively with different column value minus E column values), calculated the last column in the current empty a line, again first calculates the average value of each column data every 30,
emmm.... Don't know if I describe clearly the , I uploaded the handwritten a graphic, I will only write step by step, we calculate the code, but the parameters involved in the change code is very inconvenient, consult everybody how to use the loop statement or other statements to operate the process to me? Appreciate
CodePudding user response:
Written in formula, a good, filling, only need to pay attention to, because the columns of the decrease is in the same column E Numbers, so add an absolute reference to E $sign, ensure E remains unchanged, the rest of the EXCEL will help you to complete,
With you on the graph example Step 1, give the results of the first cell assignment, as shown in figure, you give S1 cell assignment "=F1 - $E1"; Step 2, fill in the first row, S1 selected cell, put the mouse on the cell of the lower right corner, press the left mouse button, drag to the right, until you want to populate the data of the last column to stop, Step 3, fill the rest of the data, all selected to populate the data cell (including have just fill the data of the first row), and then Ctrl + D, filling data, complete
, I uploaded the handwritten a graphic, I will only write step by step, we calculate the code, but the parameters involved in the change code is very inconvenient, consult everybody how to use the loop statement or other statements to operate the process to me? Appreciate 
