+ Reply to Thread
Results 1 to 2 of 2

Distribution Formula Needed

  1. #1
    Registered User
    Join Date
    11-27-2022
    Location
    earth (Isle of Sodor)
    MS-Off Ver
    MS Excel 2019
    Posts
    22

    Distribution Formula Needed

    Hello All:
    Does anybody have a formula that does the following:

    Given: Number of numbers (Value in a specific cell)
    Given: MIN START (Value in a specific cell)
    Given: MAX END (Value in a specific cell)

    ALL NUMBERS GENERATED SHOULD BE WHOLE NUMBERS (ODD OR EVEN)
    Each NEXT number should be > the last number (evenly distributed across the range). Repeated numbers only if RANGE is < the 'Number of numbers'
    Generate a list (evenly distributed across the range) of n 'Number of numbers' across the range FROM MIN START - MAX END

    EXAMPLE:
    Given: Number of numbers = 5
    Given: MIN START = 1
    Given: MAX END = 13

    Answer should be something like this: 1, 4, 7, 10, 13

    ALL NUMBERS GENERATED SHOULD BE WHOLE NUMBERS (ODD OR EVEN)
    Each NEXT number should be > the last number (evenly distributed across the range). Repeated numbers only if RANGE is < the 'Number of numbers'
    Generate a list (evenly distributed across the range) of n 'Number of numbers' across the range FROM MIN START - MAX END
    Attached Files Attached Files
    Last edited by ThomasTrain; 04-13-2023 at 09:58 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Formula Needed

    Hello to you too
    not very descriptive thread title isn't it?

+ 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] Improved Formula / i've run out room to extend the current formula / (avdanced code needed
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2018, 06:19 AM
  2. date formula help needed with blank cell and monthly assumtions formula needed
    By Michael.Howarth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2018, 07:47 AM
  3. Replies: 3
    Last Post: 04-06-2016, 12:19 PM
  4. Replies: 1
    Last Post: 01-11-2016, 02:31 PM
  5. [SOLVED] Formula needed to depend formula's range on specified cells
    By VincentNL in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-01-2014, 06:15 AM
  6. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  7. Replies: 3
    Last Post: 09-07-2012, 12:07 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