I need MS-Excel Macro/formulae code logic to solve following puzzles.
1. Find out all combination of 2 numbers whose whose sum is 100. (like 40+60, 30+70, 99+1)
2. Find out all combination of 2 numbers from database of values whose sum is 100. [i.e. Database of numbers{stored in excel sheet}: 40,91,99,1,9,2,60 etc.. Output40,60) (99,1) (91,9)]
Thanks & Regards
Vasant
Have a good day ahead.
Bookmarks