I am a self employed Excel trainer that teaches basic, intermediate and advanced Excel to various groups. I can handle most questions, but I was stumped in the class today.
Here is the scenario. Given a set of numbers in a range, and a separate cell with an individual number in it, is there a way to look at that individual cell and determine how many possible combinations of numbers there could have been from the original set of numbers in a range that made up the answer equal to that number. I dont know how to attach a screenshot, but I have an example i can send... Here is what was asked... 100 200 300 50 80 20 10 Above is the range of numbers here is the answer: 160 >From the original list, what possible combinations of numbers could be added to get to that answer. (Just looking at the list you can see that 100+50+10 is one combination as well as 80+20+10 as another.) The person just wants to know the cell locations of all the cells that could have gone into make this number. The result in this case would be 100,80,50,10 as all the possible number combinations. Any help? --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---