+ Reply to Thread
Results 1 to 2 of 2

How to group numbers in Excel

Hybrid View

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to group numbers in Excel

    I have a list of numbers 00100-93649, not all the numbers are there. How can I get groupings for the numbers that are there. if I am missing 00105 and 00112 I want my groups to be 00100-00104 and 00106-00111. Is that even possible?

  2. #2
    Registered User
    Join Date
    11-14-2012
    Location
    Brooklyn, NY
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How to group numbers in Excel

    Please see attached, is this what you're looking for? (please note the formulas in 'A' you need to pull it down as you entermore info)

    Than you
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1