1726
Developer's Corner / 'Sorting/grouping' methodologies
« Last post by Target on March 26, 2008, 01:10 AM »I have a request from a colleague to assist with sorting and grouping data (in Excel) into blocks of X records (in this case 500), but I have no idea how to go about this
Sorting and subtotalling the data is not a problem, however I have no idea how to go about sorting the results into the requisite blocks (I'm presuming some efficiencies here, ie some sort of best fit type arrangement)
I've googled sorting without joy - clearly this isn't an exact fit but I really have no idea what what it is i should be searching for
The only examples I know of are tools like FillCD or Burn To The Brim (for filling CD/DVDs) but I have no idea how they do what they do
any suggestions?
Target
Sorting and subtotalling the data is not a problem, however I have no idea how to go about sorting the results into the requisite blocks (I'm presuming some efficiencies here, ie some sort of best fit type arrangement)
I've googled sorting without joy - clearly this isn't an exact fit but I really have no idea what what it is i should be searching for
The only examples I know of are tools like FillCD or Burn To The Brim (for filling CD/DVDs) but I have no idea how they do what they do
any suggestions?
Target

Recent Posts

), but had been wondering how you were getting on 
