+ Reply to Thread
Results 1 to 3 of 3

Footbal- top scorer excercise- how to find a unique top scorer between two dates

  1. #1
    Registered User
    Join Date
    02-25-2015
    Location
    Leeds
    MS-Off Ver
    2010
    Posts
    2

    Footbal- top scorer excercise- how to find a unique top scorer between two dates

    Hi

    I wonder if anybody can help. The task is to find a top scorer (in cells C16-C27) for a particular club at certain date. saved file: football task.xlsx

    I tried various Vlookups, sumifs but I hit a wall

    footbal.jpg

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Footbal- top scorer excercise- how to find a unique top scorer between two dates

    See how this works for you.
    Attached Files Attached Files
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    02-25-2015
    Location
    Leeds
    MS-Off Ver
    2010
    Posts
    2

    Re: Footbal- top scorer excercise- how to find a unique top scorer between two dates

    Hi
    Many thanks!!! I will transfer the formulas to the main file and see if they can deal with the other exceptions. thanks again.

+ 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. Highest scorer with multiple condition
    By Naresh Maloo in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-24-2014, 05:18 AM
  2. highest scorer
    By Naresh Maloo in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-23-2014, 06:34 AM
  3. [SOLVED] Need to do ranking top 5 scorer
    By carrillod in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 04:29 PM
  4. [SOLVED] Duplicate Names When Picking Out Highest Scorer
    By webstmonkey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2013, 09:51 PM
  5. Picking out the name and score of the highest scorer
    By jimmymcmahon in forum Excel General
    Replies: 10
    Last Post: 08-06-2011, 05:44 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