If I understand the question correctly, then you could resolve this with an approach like this:
The important formula is as follows:
Enter this into cell
F2 and drag the right bottom corner all the way down to the end. then
G2 contains the formula
Note that the number 8 in
F2 is just to match the example screenshot, which has rows running from 2 to 6. If you need to run to 163, then you need to adjust the formula accordingly.
You could do this without the helper column, fold everything into a more complicated formula. However, for now I am not even sure whether this is what you are looking for...
An example of the workbook is uploaded here
After you provided the guiding XLS, I understood that the calculation you need is actually more complex. Copying from your uploaded XLS, what you need are the following formulas, where each next cell in the row gets more complicated:
and so on.
This looks like a sort of
but with columns
K reversed in order, and with the lengths of the column depending on the row you are calculating.
Anyway, the best I could come up with, was to introduce two helper columns
O that contain the up-side-down versions of columns
K, and then use the following formula in column
Credits go to this answer for the
O are filled as follows:
Corresponding picture (with a slight change in the formula, but I did not care to re-take the screenshot...):
I uploaded the corresponding workbook here. Of course, you have to edit some of the formulas to support longer columns. Or make everything completely dynamic, which is not too hard but results in long formulas.
If you do not like the view of the helper columns
O, then you can hide them.