+ Reply to Thread
Results 1 to 3 of 3

Calculate all 3 team Combinations with no repetitions

  1. #1
    Registered User
    Join Date
    10-28-2020
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    2

    Calculate all 3 team Combinations with no repetitions

    Hi there,

    I want to calculate all the 3 team combinations out of 4 or more teams, up to 15, with no repetition. So for example, I like the following NFL football teams to win this Sunday: KC, TB, GB, TEN (KC=KANSAS CITY, TB=TAMPA BAY, GB=GREEN BAY, TEN=TENNESSEE).

    So the combinations would be:

    1. KANSAS CITY, TAMPA BAY, GREEN BAY
    2. KANSAS CITY, TAMPA BAY, TENNESSEE
    3. KANSAS CITY, GREEN BAY, TENNESSEE
    4. TAMPA BAY, GREEN BAY, TENNESSEE

    I think that is all the combinations using four teams. Then I would buy four, 3-team parlay tickets
    here at: proline.ca/#pointspread you can watch a short video there as well to further clarify.

    LIST NUMBER 3058
    NO. TIME SPORT VISITORS HOME V H

    THU OCT 29
    14 8:15PM ftb ATLANTA CAROLINA -3.0

    SUN NOV 1
    1 1:00PM ftb PITTSBURGH BALTIMORE -3.5
    2 1:00PM ftb LOS ANGELES-R MIAMI -4.5
    3 1:00PM ftb NEW YORK-J KANSAS CITY -20.0
    4 1:00PM ftb MINNESOTA GREEN BAY -7.0
    5 1:00PM ftb INDIANAPOLIS DETROIT -3.0
    6 1:00PM ftb LAS VEGAS CLEVELAND -2.5
    7 1:00PM ftb TENNESSEE CINCINNATI -6.0
    8 1:00PM ftb NEW ENGLAND BUFFALO -4.0
    9 4:00PM ftb LOS ANGELES-CH DENVER -3.5
    10 4:15PM ftb SAN FRANCISCO SEATTLE -3.0
    11 4:15PM ftb NEW ORLEANS CHICAGO -4.0

    MON NOV 2
    13 8:15PM ftb TAMPA BAY NEW YORK-G -11.5


    I have excel 2013. Anything in excel or sheets would be greatly appreciated.

    Thanks in advance for your help,

    Label
    Attached Files Attached Files
    Last edited by Label; 10-29-2020 at 09:44 AM. Reason: To add more information & to clarify

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Calculate all 3 team Combinations with no repetitions

    .

    Will this do ?


    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-28-2020
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Calculate all 3 team Combinations with no repetitions

    Hi Logit,

    Thanks a lot for your prompt reply, I really appreciate it.

    I made a few changes to the original post to expand and clarify.

    Hope this helps. I am a real beginner at all of this.

    Also, hope you like my football picks Last week I went 12/13 on the pools which sounds good, but you only win if you get them all correct

    Take care,

    Label

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Possible combinations to create a team automatically
    By ksj2020 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2020, 01:05 AM
  2. Number of repetitions in a collumn and counting those repetitions
    By ctrc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2017, 11:36 AM
  3. Find combinations with different repetitions for each cateogories
    By macronewbie9981 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2016, 05:15 PM
  4. [SOLVED] How to calculate the team and individual attendance?
    By rajeshntiwari in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-06-2015, 03:02 PM
  5. [SOLVED] Calculate the Home Win Streak for a team
    By JO505 in forum Excel General
    Replies: 21
    Last Post: 02-13-2015, 01:46 PM
  6. [SOLVED] Calculate Team Standings
    By Dougiebn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2013, 10:10 PM
  7. creating a list of team combinations
    By kirchok1995 in forum Excel General
    Replies: 2
    Last Post: 07-14-2010, 07:33 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1