+ Reply to Thread
Results 1 to 2 of 2

How to make a dynamic formula to distribute a pre-set number of customers evenly throughou

  1. #1
    Registered User
    Join Date
    06-19-2017
    Location
    Boston, Massachusetts
    MS-Off Ver
    2010
    Posts
    1

    How to make a dynamic formula to distribute a pre-set number of customers evenly throughou

    I'm working on a model to forecast a company's cash flows. One of the features I need the model to have is a changeable number of customers (i.e. 25 customers) and I want Excel to take that number and relatively evenly distribute it throughout 12 months in the year. 25 being an odd number, I'd expect something like 2 customers/month and 3 customers in December.
    Any ideas on how to make this dynamic calculation so I can change the number of customers with one click? Obviously, the number of customers need to be integers. Thanks in advance for your help.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to make a dynamic formula to distribute a pre-set number of customers evenly throu

    A1 = # of customers
    A3 copied to the right (to L3)
    =INT($A$1/12) +IF(MOD($A$1,12)> 12-COLUMNS($A$3:A$3),1,0)
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. Replies: 12
    Last Post: 02-12-2017, 06:09 PM
  2. Evenly distribute a number across several cells
    By gbursson in forum Excel General
    Replies: 2
    Last Post: 02-18-2015, 05:51 AM
  3. [SOLVED] Help with Formula to Distribute evenly based on pack size of item...
    By blue84rain in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-29-2014, 05:53 PM
  4. Distribute Data Evenly
    By sohlican in forum Excel General
    Replies: 13
    Last Post: 09-19-2014, 07:37 PM
  5. Distribute variables evenly
    By Jovanator in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2014, 12:15 PM
  6. Evenly distribute numbers
    By captain118 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 01:27 AM
  7. trying to distribute evenly between number of people
    By magleremm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2012, 09:41 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