+ Reply to Thread
Results 1 to 3 of 3

Distribute a value with specific criteria to a data range

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    Stockholm
    MS-Off Ver
    2010
    Posts
    8

    Distribute a value with specific criteria to a data range

    Hi everyone!

    I need your help or an idea how to find out a smooth way to calculate it the following problem.

    I have a range of data range of 5 cells (B3,C1,D1,E1,F1) and a cell with a adjustment value (G1) that I have to distribute on the data range in the following way:
    - If a cell from a data range is 0, will remain 0.
    - if a cell has a negative value from a data range than i will draw of from the adjustment value (G1) until is 0
    - If after this this procedure will remain a positive value in (G1) that will be distribute on the cells with positive value from the range, distributed according to the percentage value of positive values
    - if all cells from the data range will be 0 and in (G1) still we have a positive value than the remained value will be added to A1.
    - if F1=0 and in the data range stil we have a negative value then we will draw of from the positive values in the data range.

    I hope that it's understandable

    Atached I send an exemple.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-08-2014
    Location
    Stockholm
    MS-Off Ver
    2010
    Posts
    8

    Re: Distribute a value with specific criteria to a data range

    Meanwhile I resolved the problem.

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Distribute a value with specific criteria to a data range

    Hi, Glad to see that , can you post your solution ... ?
    Click just below left if it helps, Boo?ath?

+ 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] One formula to average specific criteria from data range
    By nicki_rae22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 02:33 PM
  2. [SOLVED] Want to Distribute Data from Sheet A to the other sheets based on Criteria
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 04-13-2013, 09:27 PM
  3. Want to Distribute Data from Sheet A to the other sheets based on Criteria
    By jordan1214 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2013, 08:45 PM
  4. A formula to distribute data into specific named columns
    By Jdonjuan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-30-2012, 10:44 AM
  5. Distribute data amoung agents based on specified criteria
    By mike22183 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2009, 01:20 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