+ Reply to Thread
Results 1 to 3 of 3

Filling 2 numbers with an interval

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010 & 2019
    Posts
    21

    Exclamation Filling 2 numbers with an interval

    I have a problem with a list I want to generate.

    I start with a table like this:

    KP Start KP End Height Value ?
    0 25 0 1
    25 50 1
    50 75 0 1
    75 100 2
    100 1



    Now, I would need to have a macro making a list which fille in the numbers of KP Start and KP End with a certain inteval, but only for the rows where there is no "1"in the last column.
    So in the previous example, I would need to get a list as following (with an inteval of 5m for example).

    25
    30
    35
    40
    45
    50
    75
    80
    85
    90
    95
    100




    Does anybody know if this is possible?


    Thanks in advance!


    Michael

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Filling 2 numbers with an interval

    Michael - I don't see how your output relates to your table. Have you looked at AutoFill?

    Perhaps post a workbook?

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010 & 2019
    Posts
    21

    Re: Filling 2 numbers with an interval

    --- This thread can be deleted. I accidentally posted it twice ---

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Avg numbers in specified interval from non-interval data
    By weeble33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2013, 07:27 PM
  2. [SOLVED] Filling in Ascending Values between Two Interval Columns
    By afufoo in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-21-2013, 08:07 AM
  3. [SOLVED] Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  4. Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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