+ 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
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Filling 2 numbers with an interval

    Duplicate post?

    http://www.excelforum.com/excel-prog...-interval.html
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

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

    Re: Filling 2 numbers with an interval

    Attached more or less what I've come up with.

    The list is generated starting in Cell A18 downwards.


    1 problem I have is that when I for example generate the list from 100 to 125 with an inteval of 2. I will get a list from 100 to 124. So number 125 is skipped.
    Can this be solved?
    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)

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. 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