Thread: 5000 rows, want to select and perform addition on ever 48 rows
View Single Post
 
Old 06-09-2019, 10:09 PM
Rexmaverick Rexmaverick is offline Windows 10 Office 2016
Novice
  
Join Date: Jun 2019
Posts: 3
Rexmaverick is on a distinguished road
Default 5000 rows, want to select and perform addition on ever 48 rows
Hi,

Thank you for having a look, I have done this years ago and cannot remember how to achieve it again,

As above I have approx 5000 rows, I wand to select O2:048 and put result in p48, then select O49:O97 and put result in P97, then O98:O145 and put result in P145.

Appreciate any assistance

Rex
Reply With Quote