#1
|
|||
|
|||
parsing numbers from a list
Hi all,
I need help with parsing numbers out of a Number list into separate number lists or groups…. maybe a macro? Say I have a list of number in column A, starting at A1, the list could be from 01 to 60, but usually the List is a bunch of random misc numbers, but never exceeding 60. I need to parse the numbers into 10 different groups, 1-6, 7-12, 13-18, 19-24, 25-30, 31-36, 37-42, 43-48, 49-54, 55-60. I have an example spreadsheet attached. The number list in column A is updated and changes daily. Thank you for your help. Dave |
#2
|
|||
|
|||
Is it like in the attached?
Please note that I have set up some helper cells in row 1. You can, if you wish, make these numbers invisible or move them to somewhere out of sight. |
#3
|
|||
|
|||
xor,
Thank you for your help, your solution works perfectly. Dave |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Xml parsing error | SueR | Word | 0 | 03-21-2018 03:21 AM |
Parsing Code Macro Trouble! | Snaybot | Excel Programming | 1 | 05-15-2016 08:33 PM |
VBA to highlight numbers from an excel list | mbesspiata3 | Word VBA | 1 | 04-19-2016 04:20 PM |
Dropdownlist-Parsing values to various ContentControls | highrise955 | Word VBA | 9 | 03-08-2016 02:03 AM |
XML parsing & Object variable not set (Error 91) | tinfanide | Excel Programming | 0 | 12-29-2011 08:43 AM |