ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   permutation (https://www.excelbanter.com/excel-programming/429903-permutation.html)

devildog8692

permutation
 
need a formula to make the lowest permutation in a number combination


Tim Williams[_2_]

permutation
 
need to put more effort into question

Tim

"devildog8692" wrote in message
...
need a formula to make the lowest permutation in a number combination




Jacob Skaria

permutation
 
You need to elaborate a bit more..If you are looking at number of combinations
Say; for example how many ways can 4 students from a group of 15 be lined up
for a photograph?

Formula
=FACT(15)/FACT(11)

In VBA you can use the same as Worksheetfunction.Fact()

If this post helps click Yes
---------------
Jacob Skaria


"devildog8692" wrote:

need a formula to make the lowest permutation in a number combination



All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com