23 January 2014
SIR/MADAM, I AM CONFUSED, PLEASE HELP ME OUT... IN EXCEL SHEET, I HAVE A SET OF NUMBERS IN A COLUMN, NOW OUT OF THIS LIST OF NUMBERS IN A COLUMN I WANT TO KNOW THE SET OF NUMBERS THAT SUM OUT TO CERTAIN NUMBER. EG.IF THE LIST CONTAINS NUMBERS AS FOLLOWS :- 5,6,8,2,3,7,5. AND MY REQUIRED TOTAL IS 21, NOW I WANT TO WHAT ALL CELL REFERENCES ADD UP TO 10 IN TOTAL. IN THIS CASE SOLUTION IS 6,8 AND 7. PLEASE HELP ME OUT WITH SOME FORMULAS OR EXCEL TOOL THAT WILL HELP ME TO GET THE REQUIRED SOLUTION. AWAITING FOR YOUR RESPONSE...
CAclubindia
