Dilip, I hope you are well.
I think this is fraught with options and complications. I think it best to limit to just two digits. Thanks Michael From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: 15 April 2010 12:25 To: excel-macros@googlegroups.com Cc: Drayton, Michael E [ICG-GTS] Subject: Re: $$Excel-Macros$$ Permutations and combinations Dear Michael, So do you want only two numbers to sum up - at a time 1+19 or you want scenarios like below:- 5+5+5+5 -> means more than two digits. ? -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com<mailto:dilipan...@gmail.com> dilipan...@yahoo.com<mailto:dilipan...@yahoo.com> New Delhi - 62, India On Thu, Apr 15, 2010 at 12:51 AM, MD18358 <michael.e.dray...@citi.com<mailto:michael.e.dray...@citi.com>> wrote: Hi All: I don't want the "number of Permutations" I want to see the permutations to a calculated sum. For example: How many different ways can I get 20 by looking at the number 1 through 19. My answer should look like: 1+19 2+18 3+17 4+16 ...etc Any ideas??? As always, Thanks c -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
