Results 1 to 4 of 4

Distribute a total value evenly to an amount of cells considering certain conditions

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2017
    Location
    ecuador
    MS-Off Ver
    2010
    Posts
    2

    Exclamation Distribute a total value evenly to an amount of cells considering certain conditions

    Hi to all,

    I wonder if someone could help me with a VBA code (formula) or excel formula in order calculate a distribution:

    EJEMPLO.png

    As shown in the image, i want to make a distribution of a total value between A to F (B2: F2),

    The formula should consider:

    1) Distribute the amounts considering the demand as a priority.
    2) It should distribute in a way where every Segment A to F receives 1 unit in order till the total value stocks out.
    3) When a DEMAND is fullfilled it should pass to the next Segment.
    4) ONLY when all demands are fullfilled it should asign evenly 1 unit to all segments until it stocks out.

    Example:

    Total value = 6

    The distribution should start with

    E =1 then
    D= 1 then
    C= 1 then
    B= 1 then
    A= 1 till now 5 units are asgined then it should start with E again

    Final result:

    E =2
    D= 1
    C= 1
    B= 1
    A= 1

    Thank you!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Distribute Data Evenly Among n Cells
    By TimBZKK in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2018, 02:02 AM
  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] Distribute Tasks Evenly
    By karthikcoep in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2015, 05:48 AM
  4. Distribute variables evenly
    By Jovanator in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2014, 12:15 PM
  5. Distribute Values Evenly Across Cells
    By Crunchmeister in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-09-2014, 08:10 AM
  6. Evenly distribute numbers
    By captain118 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 01:27 AM
  7. Replies: 1
    Last Post: 11-29-2010, 09:09 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