| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add rows at fixed intervals-add values after every 5
You are too much! More blessings for you.
"Dave Peterson" wrote: I would add another column (say A) and put this in A2: =INT((ROW()-2)/5) And drag down. Then I could select my range and do Data|Subtotals and create a subtotal based on that column. TUKUR wrote: My data is in a single Column from Row 2 to 6000. I need to add the values after every 5 Rows. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Merge data rows at fixed ratio | Excel Discussion (Misc queries) | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Extracting rows based on fixed criteria | Excel Discussion (Misc queries) | |||
| fixed Rows at top of sheet | New Users to Excel | |||
Threaded Mode
