Hi every one I am new to this form and new to excel as well... I need some help hopping some one can help me out If a column lets say "A" has numbers ranging from 200 to 1200 I want to find out if any two or three combinations of numbers can find sum of 1200 or under... this is to maximize the sheet which is 1200 lets say if I have numbers like 253256262265272280285290290300300302320321324325325325330340341345347352354 355363370375375380385396406412420426428431431438440443450450454455455468470 479484490490490490493506506518540558567569572591599599600600600600600600600 601615615620621621625635638651652665667677687687694700710713716721722727742 750750750750756777780780800810811813822822825835835836838848850850850850850 850850850850850850850870870876880888888892896900915930938950950951957960960 96096196497197599510001010101010101010101010101012102110401048106510691082 1085108510991104111011161140114011531159116311761179120012001200 I need to find as much as higher number as possible as off now I am doing manually any help is greatly appreciated thank you
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.