+ Reply to Thread
Results 1 to 5 of 5

Generate Array of Numbers Specifying Min, Max and Fixed Interval

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Question Generate Array of Numbers Specifying Min, Max and Fixed Interval

    Hi All,

    I am looking to generate an array of results linked to my data range.
    Conditions are:
    - Start from a minimum number within the data range
    - fixed increments (hard coded) or linked to another cell
    - End with a maximum number within the data range

    e.g. if i have in my data range - {1,2,3,4,5,6,7,8,9,10}
    and if my condition for increment is "0.50"
    I am looking for a way to generate the array - {0.50,1,1.50,2,2.50,3,3.50,4,4.50,5,5.50,6,6.50,7,7.50,8,8.50,9,9.50,10}

    Any help is appreicated.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,410

    Re: Generate Array of Numbers Specifying Min, Max and Fixed Interval

    Assum A1:A11 is range 1:10
    B1 = 0.5
    In B2:
    =MIN($B$1,$A$2:$A$11)
    B3:
    =IF(B2<MAX($A$2:$A$11),$B$1+B2,"")
    Drag down
    Attached Files Attached Files
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: Generate Array of Numbers Specifying Min, Max and Fixed Interval

    I am not looking for Drag down,
    I am looking for array result Automatic Spill (latest Excel facility)

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,410

    Re: Generate Array of Numbers Specifying Min, Max and Fixed Interval

    To create an arrray, try:

    =ROW(INDIRECT("1:"&10/0.5))*0.5

    with 1, 10 and 0.5 is dynamic

  5. #5
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: Generate Array of Numbers Specifying Min, Max and Fixed Interval

    Yes, I can work on that basis towards my objective.
    Even I am trying to specify the minimum and maximum rows via a dynamic function
    Thanks anyway.

+ 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. [SOLVED] Need help adapting a formula to generate a random array of non-repeating numbers
    By MalibuLX3 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-11-2016, 08:56 AM
  2. Auto Pasting at fixed interval
    By Navin Agrawal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2016, 08:10 AM
  3. Replies: 7
    Last Post: 05-07-2016, 10:34 PM
  4. How can I generate an array of numbers?
    By tommade in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-10-2016, 05:00 PM
  5. How to add suffix to cell in an fixed interval
    By GuyMor in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-08-2014, 05:49 PM
  6. [SOLVED] Button to generate numbers from interval 0.0xx to 0.0yy
    By teh.format in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-05-2014, 06:04 AM
  7. Fixed cells interval
    By vitaleg in forum Excel General
    Replies: 4
    Last Post: 09-18-2010, 04:00 PM

Tags for this Thread

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