Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Its an array of 20 integers. I want to sort them 4 at a time. Like your
result 1 below. John Shane Devenshire wrote: Hi John, How about a little more info - is the a VBA array or are you using VBA to sort a range in the spreadsheet? What do you mean by 4 elements at a time - do you want to sort 4 elements internally or do you want to sort a large collection keeping every four elements together? 1 5 4 3 6 10 8 7 Result 1: 1 3 4 5 6 7 8 10 Bob Cratchet 1054 West 1st Street Washington DC Adam Smith 43 Glover Blvd London Result 2: sorted in blocks of 4 elements based on the first line: Adam Smith 43 Glover Blvd London Bob Cratchet 1054 West 1st Street Washington DC Thanks, Shane "John" wrote in message ... How do you sort an array 4 elements at a time (or n elements at a time)? John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
obscure problem | Excel Discussion (Misc queries) | |||
Obscure Function | Excel Worksheet Functions | |||
Obscure Function | Excel Worksheet Functions | |||
Obscure userform problem | Excel Programming | |||
Obscure Question | Excel Discussion (Misc queries) |