MarioChiesa
New Member
- Joined
- Sep 10, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hello,
I have extracted data for values that are all in a single column. There’s around 8700 total rows of values in the E column. Every 25th row of the column data needs to be part of a simple avg formula…
=(MIN(E2:E25)+MAX(E2:E25))/2
I need to copy and drag this formula down to repeat for cells E26:E49 and so on. I do not know how to do this without having to directly type the range each time for each group of 24 rows of data. When I do it and drag the cell down to duplicate them, all that happens is the formula changes to E3:E26 next and so on to E4…
Can anyone please assist with this issue?
Thank you..
Mario
I have extracted data for values that are all in a single column. There’s around 8700 total rows of values in the E column. Every 25th row of the column data needs to be part of a simple avg formula…
=(MIN(E2:E25)+MAX(E2:E25))/2
I need to copy and drag this formula down to repeat for cells E26:E49 and so on. I do not know how to do this without having to directly type the range each time for each group of 24 rows of data. When I do it and drag the cell down to duplicate them, all that happens is the formula changes to E3:E26 next and so on to E4…
Can anyone please assist with this issue?
Thank you..
Mario