MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Perminations question


Posted by Jack on September 07, 2001 2:44 PM

ABCDEF or however many

What i need to do is this, not using the same letter twice and running hight A-Z how many are there must be conciquential, that is AB AC AD AE AF BC BD BE and so on, i recon 57 but would like VBA to make any list do the same

Any ideas? One for the VBA guru's


Posted by Barrie Davidson on September 07, 2001 2:54 PM

Have you tried the COMBIN Worksheet Function. From Excel help,

Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.

Syntax
COMBIN(number,number_chosen)

Number is the number of items.
Number_chosen is the number of items in each combination.

BarrieBarrie Davidson