Apr 21 2021 07:13 AM
Please, I'm needing to create a sequence of averages. for example, I need the first to go from A1: A5, right after A6: A10, A11: A15 .... How do I get Excel to understand this formatting?
Apr 21 2021 07:48 AM
SolutionYou may try something like this...
=AVERAGE(OFFSET($A$1,(ROW(A1)-1)*5,0,5))
and then copy it down.
Apr 21 2021 10:37 AM
Apr 21 2021 01:01 PM
Apr 21 2021 07:48 AM
SolutionYou may try something like this...
=AVERAGE(OFFSET($A$1,(ROW(A1)-1)*5,0,5))
and then copy it down.