I need to update 45 cells in the diagonal manner as shown in the attached pic. Every updation requires that one cell below each column gets filled with an integer value.Currently, we draw excel pivots and replace all the values for all the rows, but we intend to move to a system where only one diagonal set of values needs to be updated.This needs to be updated every month, hence a long term solution is needed which minimizes manual work
Please advice on the following:
1)Can I create a named set of (say 1000) cells starting from 10 cels below the first non empty cel in each column? I would then require a formula which checks for the first non zero value in this set and apply this formula to the destination cel (the uppermost non zero cel?)
I would then paste one diagonal every time and the report would automatically pick up the cels. Please note that the next time it would have to take the 2nd non zero value and so on......
2)Is there any way to drag a formulae diagonally? I would then not need any of the above as I can simply refer to the pivot and drag
3) Any other ideas.
Any help would be appreciated-
R B G
Bookmarks