Results 1 to 16 of 16

Find the winner and percentage difference between two teams

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-30-2018
    Location
    Sweden
    MS-Off Ver
    2016.
    Posts
    397

    Find the winner and percentage difference between two teams

    I want to find the winning team based on four different scores between the two teams.

    I want to output which teams that wins and what the percentage score difference is.

    I am not sure about how the percentage difference should be calculated.

    See attached workbook for more information.

    There are different max scores for the five different routes. Ideally, I would like to enter the max score for each route and then calculate the % difference!

    Desired output is:

    Teamname ( % difference in scores between winning team and runner up)

    Ex.

    Walkers (75%)
    Runners (49%)
    Attached Files Attached Files
    Last edited by waimea; 09-02-2019 at 06:07 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] [SOLVED] Try to find the difference by percentage between 2 cell totals
    By chedd via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-08-2006, 09:20 AM
  2. how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  3. how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-07-2005, 08:05 AM

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