+ Reply to Thread
Results 1 to 2 of 2

How can I obtain the most played teams in my Dart League

  1. #1
    Registered User
    Join Date
    12-12-2015
    Location
    Costa Rica
    MS-Off Ver
    2013
    Posts
    2

    How can I obtain the most played teams in my Dart League

    I have a spreadsheet where I have 57 different teams. Everytime a game is played I enter the team number in the corresponding column (they used to use a "1") but I thought that changing it to the team number so I could be able to sort things easier. I also added a 9 to the first 9 teams so I would be sorting all 2 digit numbers and not have to worry about repeating charaters 1-9. I would like to be able to sort the rows based on combinations of 2-4 teams to see how many times those 2-4 teams have played against each other.
    Attached Files Attached Files
    Last edited by Ibet; 09-17-2017 at 10:41 PM. Reason: Changed fields

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Index, Match, Countif. Large formula or ???

    Hi, welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Formula - Index / Match / Large
    By jsneak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2015, 07:46 AM
  2. Index, Match, Large and Countif
    By rbirch in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-11-2015, 05:36 PM
  3. [SOLVED] Creating a sorted list, using INDEX, MATCH, LARGE, COUNTIF
    By amnesiac77 in forum Excel General
    Replies: 7
    Last Post: 07-25-2014, 10:56 AM
  4. Simplifying Large Index Match Formula down
    By midwest trader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 09:07 PM
  5. Index Match with Large and If Formula - Not Working
    By richoconnor in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2014, 10:37 AM
  6. VLOOKUP or INDEX/MATCH Formula that uses LARGE, IF, and OR
    By tj2434 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2014, 10:16 AM
  7. [SOLVED] Index/Match using Large Formula
    By Steve0492 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2013, 04:08 AM

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