all combinations

  1. M

    VBA Code or Formula to get all combinations of 2 cells on each row

    Hi all. I'm looking for some code or a formula that will solve the following issue that I have. This is to work out all the combinations regarding the order of goals scored within a football match. Basically the H means Home Team and the A means Away team. The requirement is to get all the...
  2. E

    Generating a list of combinations (similar to Cartesian Product but more than 1 from each list)

    Long time reader first time asker! I have a set of data and I am looking to generate a list of the combinations, I have found VBA and formulas but can't seem to get it right. It is similar to the Cartesian Product but rather than it being one from each list, there are multiples from each list...
  3. R

    all combinations without repeats

    Hi, I am unsure if this already exists but have spent days looking for what I need and cannot find it. What I am looking for is a VBA that will provide all possible unique combinations within a range. The range will be variable to input - in column A from 1 to 12 entries. Lets say- A1 -...
  4. G

    Getting all combinations of hourly data (without repetition) for calculating daily average.

    Hey guys. I'm trying to create a code on vba that generates all the daily averages for different combinations of hourly data, starting with the full 24 hour data, and then averaging all the combinations of that day with 1 hour less, then all the combinations with 2 hour less, and so on untill 8...
    • Garluis
    • Thread
    • all combinations averages averaging data combinations if statement
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top