Hi All,
Check this excel.
Regards,
Swapnil.
On Fri, Apr 16, 2010 at 1:51 PM, MD18358 wrote:
>
> GAURAV and everyone.
>
> Thank you so much for the collective energy to resolve my questions.
> It seems like it was a great brain teaser.
>
> Here is my confession. I realize "now" that this has
GAURAV and everyone.
Thank you so much for the collective energy to resolve my questions.
It seems like it was a great brain teaser.
Here is my confession. I realize "now" that this has tremendous
practical use in business and school. However, I needed this
assistance for a much "higher callin
Hi All,
I think in my attachment u will get your solution.
Thanks & Regards,
Gaurav Jain
On Fri, Apr 16, 2010 at 10:33 AM, Vikas Chouhan wrote:
> hijust chk
>
> On Thu, Apr 15, 2010 at 12:51 AM, MD18358 wrote:
>
>> Hi All:
>>
>> I don't want the "number of Permutations" I want to see the
>>
hijust chk
On Thu, Apr 15, 2010 at 12:51 AM, MD18358 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 lik
mplications.
> 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$$ Pe
]
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 981
Thanks Harmeet for the suggestion.
But I believe, Fact function is used for FACTORIAL ( which we had studied in
Maths)
5! =
5 X 4 X 3 X 2 X 1 = 120
I believe if we need to add only two numbers and that too from 1 to 19 then
below is the correct scenario for that:-
1 19 20 2 18 20 3 17 20
For that use FACT formula...
=fact(5)
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Thu, Apr 15, 2010 at 4:55 PM, Dilip Pandey wrote:
> 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 -
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
dilipan...@yahoo.com
New Delhi - 62,
