I have an excel that need to Provide the range of data everyday. And I have 20 cells with different averaging column but the row is same. So, I need to manually change the range to every cells for 20 cells everyday.
Example: average(D5:D10), Average(I5:I10), Average(H5:H10).... and so on
and on the next day I need..
Average(D6:D11), Average(I6:I11), Average(H6:H11).... and so on.
So For this I need to Manually Type the Numbers everyday to all 20 cells.
Please Provide me a Formula that I will Type the Numbers like 5:10 or 6:11 to a cell and all the 20 cell copy the Numbers from the Given Cells as the Row remain same.
Bookmarks