5000 rows, want to select and perform addition on ever 48 rows

		Microsoft Office Forums > Microsoft Excel > Excel
5000 rows, want to select and perform addition on ever 48 rows

FAQ

Thread Tools

Display Modes

06-09-2019, 10:09 PM

Rexmaverick Rexmaverick is offline

Windows 10 5000 rows, want to select and perform addition on ever 48 rows

Office 2016

Novice

Join Date: Jun 2019

Posts: 3

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to apply Heading1 to select rows	bobk544	Word VBA	3	06-09-2018 05:24 AM
How to find duplicate rows in a huge excel file containing 500000 rows	Stc25234	Excel Programming	2	06-23-2017 10:51 AM
Select rows w/cells containing given character strings, then sum cell in two other col.	LarryHills	Excel	1	02-17-2017 03:55 PM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:58 PM.