Results 1 to 10 of 10

How to get MIN and MAX of Consecutive Numbers

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    11

    How to get MIN and MAX of Consecutive Numbers

    Now here is a tricky one
    I have a table with the following numbers:
    A1 B1
    10 4115
    10 4116
    10 4117
    10 4118
    11 4125
    11 4126
    11 4127
    15 4150
    15 4151
    15 4152
    15 4153

    I need to have an output as shown below:
    C1 D1 E1
    10 4115 4118
    11 4125 4127
    15 4150 4153

    So basically, I need to group these numbers if they are consecutive and then get MIN and MAX for that set of numbers.
    Last edited by Livmi; 05-11-2015 at 12:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Consecutive numbers
    By newx in forum Excel General
    Replies: 8
    Last Post: 09-08-2015, 09:04 PM
  2. Replies: 6
    Last Post: 03-23-2012, 06:03 PM
  3. Excel macro to "fill in" consecutive numbers in non-consecutive list?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 01:13 PM
  4. Consecutive numbers
    By JamesChamp in forum Excel General
    Replies: 5
    Last Post: 03-17-2006, 08:11 AM
  5. [SOLVED] consecutive numbers
    By Monique in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-07-2005, 02:06 AM

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