I understand there is software that does this, but i would like to change stuff from time to time.
Im trying to maximize a group of numbers added together that doesn't go over 152"
I used to have this VBA code but got lost and i just cant remember it since my heart attack.
Like what are the maximum doubles that i can stack together that doesn't go over 152"?
70
70
65
57
57
57
57
75
75
75
75
75
69.5
75
57
57
57
57
57
57
57
96
96
96
96
96
96
96
Hello krturner and Welcome to Excel Forum.
I am confused as to what is meant by 'maximum doubles' when the list of numbers includes some that are used an odd number of times (i.e. 75 appears five times).
Here is my interpretation of a solution to the question, somewhat disregarding the list of numbers.
Column A has a list of doubles populated using: =ROUNDUP(ROWS(A$1:A1)/2,0)
Column B has a running sum populated using: =SUM(A$1:A1)
Column C is populated using: =MOD(ROWS(A$1:A1),2)
D1 contains the Max number (152)
F1 contains the value of the last double, and therefore the number of doubles that can be stacked and not exceed the max number, using: =AGGREGATE(14,6,A1:A100/(B1:B100<=D1)/(C1:C100=0),1)
If this isn't what you are seeking, please upload a sample (not a picture or pasted copy) by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window. Manually place the results that you want so that we can attempt to replicate them using formula(s)/code.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
My 2 cents.
Test1 does a single run(i.e A1 summed with each number in column A including itself) giving 21 results
Test2 sums each number in column A with each number in column A, including itself. This gives 441 results.
Test3 sums each number with all the numbers below it.
A1 sums with A2, A3, ....
A2 sums with A3, A4, ....
A3 sums with A4, A5, ....
I think the last one is the most accurate because A1 + A2 is in essence the same as A2 + A1
Please Login or Register to view this content.
Last edited by bakerman2; 03-25-2019 at 09:24 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks