Forum Discussion
Setting up multiple combinations of groups, and adding to test for a certain output. HELP?
I've been setting up a spreadsheet that has over 200 different items. Each item has 5 values. Each value ranges from -100 through 100. What I am wanting to find is if any combination of 3 to 5 of different items create all zeros for all 5 values when added together (Edit: also checking for -5 through 5 for all 5 values would be extremely helpful). At least one of a specific set of 25 items out of the 200 items must be included in a group. No items can repeat in any given combination of these groups.
Does this make sense? If so, I would really, really appreciate help with orginizing such information. I don't know where to begin, as I am still green when it comes to spreadsheets. I'll also attach a photo of what kinda of data I have. If you have any questions, feel free to ask, and I will get back to you as soon as I can.
1 Reply
I can able to understand this little bit only.
I can't get you, what you want?
Can you explain them in excel term.
For Eg.
You have item names in Column A.
And your values for that items in B,C,D,E,F Columns.
You want to check, whether if you put SUM function for range of "B2:F2" for each item, it results "zero" or put SUM for each group of item.
If not, ask your requirements one by one. Then only i can solve.
