+ Reply to Thread
Results 1 to 3 of 3

Create list of values for start and end value of range given specific interval

  1. #1
    Registered User
    Join Date
    07-18-2005
    Location
    Hong Kong
    Posts
    5

    Create list of values for start and end value of range given specific interval

    Hi all,

    I'd appreciate any help to gerenate a list of value based on specific interval and maximum values like below:

    Interval=10
    Max Value = 69

    A1=1
    A2=10
    A3=11
    A4=20
    A5=21
    A6=30
    .
    A13=61
    A14=69

    If the Interval is changed to 7 then the list of value will become
    A1=1
    A2=7
    A3=8
    A4=14
    .
    A19=64
    A20=69

    Thanks in advance.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444
    Hi,

    Enter 1 into cell A1

    Enter this

    =IF(A1="","",IF(A1+$E$3<$E$2,A1+$E$3,IF(A1=$E$2,"",$E$2)))

    into A2, and copy it down column A as far as you see fit.

    Make E2 your maximum and E3 your interval.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    07-18-2005
    Location
    Hong Kong
    Posts
    5
    Thanks sweep,

    It is works for me.

+ 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