| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Inserting formulas etc after n rows
I often import lists from external databases. These lists can be of variable
lenghts. Column A contains unique sorted records eg: 1234,1235,1237...1910 etc. I want to calculate a total (or preform other calculation) when the values in column A change from x2xx to x3xx (for example) and then calculate a further grand total at the end of column A. How do I do this when I don't know where the 'sections' ends will fall? Is it possible to insert these totals into column A itself? And do all of the about without VBA?! Yours hopefully.... -- Peter London, UK |
|
#2
|
|||
|
|||
|
Peter, use the Subtotals feature.
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Peter" wrote in message ... I often import lists from external databases. These lists can be of variable lenghts. Column A contains unique sorted records eg: 1234,1235,1237...1910 etc. I want to calculate a total (or preform other calculation) when the values in column A change from x2xx to x3xx (for example) and then calculate a further grand total at the end of column A. How do I do this when I don't know where the 'sections' ends will fall? Is it possible to insert these totals into column A itself? And do all of the about without VBA?! Yours hopefully.... -- Peter London, UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting rows with Data, Formula's and Validation | Excel Discussion (Misc queries) | |||
| Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
| Copying formulas to new rows, 20000 times | Excel Discussion (Misc queries) | |||
| inserting rows | Excel Discussion (Misc queries) | |||
| Rows containing "#N/A" are messing with my formulas, please help | Excel Worksheet Functions | |||
Linear Mode
