Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Microsoft XP- Home Edition.
I want to create a macro that gives me the ability to list a set of numbers and have them rearranged by a specific number. Ex. #1 I have a set of 10 numbers, say: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 I want these numbers to be rearranged in the order of every third (3) number. Therefore, the answer would be as follows: 3, 6, 9, 2, 7, 1, 8, 5, 10, 4 Ex. #2 I have a set of 20 numbers, say: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 I want these numbers to be rearranged in the order of every seventh (7) number. Therefore, the answer would be as follows: 7, 14, 1, 9, 17, 5, ............etc. Best Regards! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a New Macro | Excel Discussion (Misc queries) | |||
Macro Creating | New Users to Excel | |||
Need Help Creating A Macro | Excel Worksheet Functions | |||
Creating a Macro | Excel Programming | |||
Help Creating a Macro | Excel Programming |