Home

Choosing relevant data from a given data set

%3CLINGO-SUB%20id%3D%22lingo-sub-580564%22%20slang%3D%22en-US%22%3EChoosing%20relevant%20data%20from%20a%20given%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-580564%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20numbers%20of%20which%20a%20minimum%20need%20to%20be%20selected%20to%20form%20a%20given%20number.%3CBR%20%2F%3EFor%20example%3CBR%20%2F%3EMy%20data%20set%20is%202%2C%204%2C%206%2C%208%2C%2010%20and%20i%20need%20to%20select%20the%20minimum%20number%20of%20data%20that%20can%20form%20the%20number%2012.%20So%20in%20this%20situation%2012%20can%20be%20achieved%20by%20adding%202%2B4%2B6%20or%206%2B6.%20So%20I%20need%20excel%20to%20register%20that%206%20needs%20to%20be%20selected%20twice%20and%20discard%202%2B4%2B6.%20What%20can%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-580564%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
namrata1925
Frequent Visitor

I have a set of numbers of which a minimum need to be selected to form a given number.
For example
My data set is 2, 4, 6, 8, 10 and i need to select the minimum number of data that can form the number 12. So in this situation 12 can be achieved by adding 2+4+6 or 6+6. So I need excel to register that 6 needs to be selected twice and discard 2+4+6. What can I do?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies