Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2018, 08:15 PM
JBF JBF is offline parsing numbers from a list Windows 10 parsing numbers from a list Office 2013
Novice
parsing numbers from a list
 
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, 11 views)
Reply With Quote
  #2  
Old 10-13-2018, 10:42 PM
xor xor is offline parsing numbers from a list Windows 10 parsing numbers from a list Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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, 13 views)
Reply With Quote
  #3  
Old 10-14-2018, 12:33 PM
JBF JBF is offline parsing numbers from a list Windows 10 parsing numbers from a list Office 2013
Novice
parsing numbers from a list
 
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 numbers from a list 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
parsing numbers from a list 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft