Results 1 to 5 of 5

Highest to lowest results using multiple data with array formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Highest to lowest results using multiple data with array formula

    Hi,

    These are for a soccer league results.

    Once all matches have been played, it should calculate the winner of the league.

    I currently already calculated all fixtures per school. I have 7 schools participating

    I want it to calculate the most points to the lowest on the tab "league table", using the totals per school from tab "Fixtures U9"

    I have attached the current sheet I am working on

    http://www.excelforum.com/attachment...1&d=1461371141

    Thanks,
    Jacolene
    Attached Files Attached Files
    Last edited by Jacolene; 04-23-2016 at 02:46 AM. Reason: failure to comply with rule 1

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Vlookup Normal Formula (not array formula) or VBA Function Required
    By BoopathiK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2015, 03:06 AM
  2. VLOOKUP within array formula?
    By swedeaction in forum Excel General
    Replies: 1
    Last Post: 11-11-2011, 06:55 AM
  3. vlookup perhaps?, array formula
    By Greed in forum Excel General
    Replies: 6
    Last Post: 10-28-2011, 10:15 AM
  4. Using a formula within a vlookup array name
    By madadd in forum Excel General
    Replies: 14
    Last Post: 04-11-2011, 06:54 PM
  5. VLOOKUP array formula
    By kborgers in forum Excel General
    Replies: 2
    Last Post: 01-29-2010, 09:15 AM
  6. Vlookup in combine with an Array Formula
    By Mike2 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-28-2008, 09:03 AM
  7. Need Help with Array Formula using Vlookup and MAX
    By jllogan111 in forum Excel General
    Replies: 3
    Last Post: 11-07-2008, 10:06 PM

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