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