• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rearranging Rows based on multiple constrains and conditions

kamble.akumar

New Member
Hey All,

I have a query, I have 90 entries with Column for Name, minimum allowed value individually of 27 and maximum of 28.5 and sum of every two consecutive should be less than either 56 or 57, Also this sum of consecutive values has to be specifically arranged in series of 56 and 57s in order of 56-57-57-57-56.
The individual values are random ranging from 27 - 29 And finally, sum of all 90 should be less than or equal to 2547.

For this the 90 entries are initially entered as per FIFO of information.

Is there any way to re-arrange the rows from the list according to above conditions.

Any help or lead on this will be very helpful..

Thank you
Amit
 

Attachments

  • Linear.xlsx
    15.8 KB · Views: 4
Back
Top