REPOST - Detecting missing values in a sequential list of numbers

Discussion in 'Microsoft Excel Worksheet Functions' started by Chris Strug, Jun 25, 2003.

  1. Chris Strug

    Chris Strug Guest

    Hi,

    A few weeks ago I made a post asking how to detect missing values in a
    sequential number sequence.

    For example, given a column of numbers containing

    1,2,3,5,7,8,9,12,13,14,15,17,20

    I would like

    4,6,10,11,16,18,19.

    Someone posted a code sample that analyzed the column and returned a text
    box containing all the missing values.

    However, my workstation went banana's recently and unfortunately I lost the
    code sample.

    Would it be possible for the gentleman in question to repost the sample?

    Sorry to a pest. Kind thanks

    Chris Strug
     
    Chris Strug, Jun 25, 2003
    #1
    1. Advertisements

  2. Chris Strug

    Peo Sjoblom Guest

    You could always search google on your own name

    http://tinyurl.com/f7tp

    --

    Regards,

    Peo Sjoblom


    "Chris Strug" <> wrote in message
    news:iFeKa.5709$...
    > Hi,
    >
    > A few weeks ago I made a post asking how to detect missing values in a
    > sequential number sequence.
    >
    > For example, given a column of numbers containing
    >
    > 1,2,3,5,7,8,9,12,13,14,15,17,20
    >
    > I would like
    >
    > 4,6,10,11,16,18,19.
    >
    > Someone posted a code sample that analyzed the column and returned a text
    > box containing all the missing values.
    >
    > However, my workstation went banana's recently and unfortunately I lost

    the
    > code sample.
    >
    > Would it be possible for the gentleman in question to repost the sample?
    >
    > Sorry to a pest. Kind thanks
    >
    > Chris Strug
    >
    >
     
    Peo Sjoblom, Jun 25, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. michael

    Generating unique sequential numbers in Excel

    michael, Nov 24, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    1,968
    Sandy Mann
    Nov 25, 2003
  2. Guest

    Sequential names on Sequential pages

    Guest, Nov 12, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    372
    Guest
    Nov 12, 2004
  3. Guest

    sequential numbers on invoices

    Guest, Dec 2, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    232
    Frank Kabel
    Dec 2, 2004
  4. Guest

    Non-sequential VLOOKUP function -OR- sequential sort of web query

    Guest, Feb 28, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    551
    Jason Morin
    Feb 28, 2005
  5. Guest

    How do I assign sequential numbers in an Excel 2003 PO template?

    Guest, Mar 28, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    549
    Jason Morin
    Mar 28, 2005
  6. Guest

    Print sequential page numbers on one worksheet printed multiple ti

    Guest, Aug 5, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    444
    Damon Longworth
    Aug 5, 2005
  7. Darrell Shuman

    Make sequential numbers each time sheet is opened

    Darrell Shuman, Oct 18, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    332
    JE McGimpsey
    Oct 19, 2005
  8. forceten32

    Renaming Sequential Rows to create serial numbers

    forceten32, Nov 13, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    361
Loading...