Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-13-2018, 08:15 PM
JBF JBF is offline Windows 10 Office 2013
Novice
 
Join Date: Mar 2018
Posts: 6
JBF is on a distinguished road
Default 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
Attached Files
File Type: xlsx Example1.xlsx (11.7 KB, 4 views)
Reply With Quote
  #2  
Old 10-13-2018, 10:42 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 909
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

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.
Attached Files
File Type: xlsx ParsingNumbers.xlsx (14.6 KB, 6 views)
Reply With Quote
  #3  
Old 10-14-2018, 12:33 PM
JBF JBF is offline Windows 10 Office 2013
Novice
 
Join Date: Mar 2018
Posts: 6
JBF is on a distinguished road
Default

xor,
Thank you for your help, your solution works perfectly.
Dave
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 12:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft