Number combinations

[helpmeplz]

What would the formula be to calculate the number of combinations of six out of 12 total numbers?

 

[tusharm]

In XL help type in 'combination' (w/o the quotes).

 

[helpmeplz]

Oh, that was easy. I'm embarrassed! Thanks!

Now the hard part: What calculation can determine what those combinations are?

Thanks a bunch!

 

[tusharm]

Yeah, I knew that was coming. {grin}

Myrna Larson has posted code in the XL newsgroups. Check the google.com archives. A repost by Ken Wright is at
http://groups.google.com/group/micr..._frm/thread/f429449f6cc339ce/1507e1d8dea66bf8

 

[helpmeplz]

Ha, ha. Wow! That is some VBA code! Far over my head. I get a compiler error on thi line:

= True Or BufferPtr = UBound(Buffer()) Then......

I can handle some basic VBA, but I don't have a clue about this one.

 

[tusharm]

Well, I expedited an long planned project. The page, in a not-quite-finished state is
Powerset, Subset, and Combinations & Permutations
http://www.tushar-mehta.com/excel/tips/powerset.html

To use UDFSubset as an XL function, enter the elements of your set (the 12 numbers) in a column. Enter the number of selections you want (6) in some other cell. Then, select COMBIN(12,6) cells in a column and *array enter* =UDFSubset({range with 12 numbers},{cell with # to select},",")