LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default calculate all possible combination from 10 variables

Hi,
I have 10 variables and I want to write a VBA code to calculate all
possible combinations of them as the maxumum variables in a combination
(group ) could be 5 and the minimum variables in combination (group)
could be 2. For example if I have variables -- a, b, c, d, e, f, g, h,
i, j - --the max variable in combimation to be 5 - for example "a, b,
c, f, h" and minimum 2- "a, b".
Hope I made it clear..
any idea how to do that..

Thanks, silvia

 
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
Need to calculate percentage with some variables Cristin Excel Worksheet Functions 4 September 23rd 08 02:02 AM
How do I calculate maximum with variables. DanASU Excel Worksheet Functions 3 June 13th 08 08:01 PM
combination charts: two variables in one series? Bob with Q Charts and Charting in Excel 1 September 14th 06 09:55 AM
Is there an easy way calculate 2 variables in conditional sum wiz. Liketoknow Excel Worksheet Functions 1 November 10th 04 09:34 AM
calculate the derivative (rate of change) of variables Fyon Excel Programming 2 January 29th 04 03:56 PM


All times are GMT +1. The time now is 10:24 PM.

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

About Us

"It's about Microsoft Excel"