Formula - Combination of Numbers

[Nandakumar]

Hi,

I need to have a formula on the different combination of numbers for particular set of number.For Example,

4567 - combinations are

4567
4657
4675
5467 etc.

Can anyone help in a formula please!

Regards,

 

[Villalobos]

Hi,

Check this post: http://www.excelforum.com/excel-new...need-help-on-4-digit-number-permutations.html

 

[NARAYANK991]

Hi ,

Go through the following link , which has a formula by Harlan Grove.

http://www.pcreview.co.uk/threads/number-permutation-formula.1754556/

Narayan

 

[Nandakumar]

Dear Narayanank991,

I tried the formula.it is not working.
attached for your reference.

 

[NARAYANK991]

Hi ,

The reference to column F in the formula is probably a typo. Replacing all references to column F with references to column A will do the job.

See the uploaded file.

Narayan

 

[Nandakumar]

It works .Thank you so much.

 

[Hui]

Have you read:
https://sites.google.com/site/e90e50fx/home/combinatorics-using-excel-formulas-and-examples