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
|