+ Reply to Thread
Results 1 to 5 of 5

redistribute numbers using solver

Hybrid View

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    Baghdad, Iraq
    MS-Off Ver
    2007
    Posts
    3

    Re: redistribute numbers using solver

    Thank you very much for replaying Mr. Kaper ,, another question if you let me,
    i'am trying to get the closest value to 10, ok if one group gets more then 10 (10.5 , 10.4 ) but i need all other groups to be closest to 10 ,,
    in that case solver didn't really help me even if i change the condition of if ,, i need something, formula or any guide that would help me to solve this
    thank again
    my best regards
    Ahmed.B
    Last edited by AliGW; 07-16-2019 at 07:04 AM. Reason: Bold is for emphasis only, not whole posts.

+ 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. Linked data model: redistribute values when detail is not available
    By ferodo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-03-2017, 11:32 AM
  2. Redistribute data in excel
    By kay007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-11-2016, 09:56 AM
  3. Evenly redistribute numbers from goal/remaining
    By jpgrimard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2016, 06:22 PM
  4. Redistribute Budget Gap Over Remaining Months
    By Horsefly in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-26-2015, 02:26 PM
  5. Code to automatically redistribute figures dependent on scroll bars....
    By HPrice in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2014, 05:54 PM
  6. Redistribute Tables After Import (Dynamically)
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2011, 12:02 PM
  7. redistribute a column by a groups of rows
    By Bill Davis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2005, 07:06 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