Assumed we have this table style in sheet 1:
A B C D E F G H 1 0.1 0.2 0.5 0.7 0.4 0.5 0.9 1.0 2 3
In sheet 2 there have to be averages made out of the paired cells of sheet 1, means averages from A1:B1, C1:D1, E1:F1, and so on.
AVERAGE(A1:B1) from sheet 1 should be in sheet 2: cell A1,
AVERAGE(C1:D1) from sheet 1 should be in sheet 2: cell B1,
AVERAGE(E1:F1) from sheet 1 should be in sheet 2: cell C1, and so on…
A B C D 1 0.15 0.6 0.45 0.95 2 3
My assumption was to simply use the OFFSET-function with some command like that:
As the rows do not get switched, we can put a 0 into the row move option.
Unfortunately, this command does not work as expected. Any ideas?