#1   Report Post  
Old February 8th 16, 12:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2016
Posts: 1
Default Combinations

On Saturday, January 18, 2003 at 7:38:57 PM UTC+5:30, João Veríssimo wrote:
Hi!

I am trying to think how VBA/Excel could list all possible combinations /
arrangements of a set of elements, but I couldn´t manage it yet.

I think Myrna Larson had written some code for this, and that it was posted
in this newsgroup.

Notice that i am not talking about permutations, but combinations of a
(smaller) number of elements from a set.

Any one can do this?

Tham you very much,
--
João Veríssimo )




On Saturday, January 18, 2003 at 7:38:57 PM UTC+5:30, João Veríssimo wrote:
Hi!

I am trying to think how VBA/Excel could list all possible combinations /
arrangements of a set of elements, but I couldn´t manage it yet.

I think Myrna Larson had written some code for this, and that it was posted
in this newsgroup.

Notice that i am not talking about permutations, but combinations of a
(smaller) number of elements from a set.

Any one can do this?

Tham you very much,
--
João Veríssimo )




On Saturday, January 18, 2003 at 7:38:57 PM UTC+5:30, João Veríssimo wrote:
Hi!

I am trying to think how VBA/Excel could list all possible combinations /
arrangements of a set of elements, but I couldn´t manage it yet.

I think Myrna Larson had written some code for this, and that it was posted
in this newsgroup.

Notice that i am not talking about permutations, but combinations of a
(smaller) number of elements from a set.

Any one can do this?

Tham you very much,
--
João Veríssimo )


hi sir i am from india
i am doing project in vba.
i want to known how to create a combinations using text/words like aaa,bbb and numbers?

can u help me?
\

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combinations PST Excel Programming 0 April 10th 07 06:44 PM
Sum of all combinations cursednomore Excel Discussion (Misc queries) 3 December 15th 05 12:25 AM
Combinations Don Lloyd Excel Programming 2 June 29th 05 07:14 AM
Combinations Don Lloyd Excel Programming 4 June 28th 05 09:01 PM
Combinations mac_see[_2_] Excel Programming 4 February 3rd 05 06:59 PM


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017