+ Reply to Thread
Results 1 to 3 of 3

Fantasy Football Help!

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    Tyler, TX
    MS-Off Ver
    2013
    Posts
    1

    Fantasy Football Help!

    FantasyDraft.xlsx
    Please help I'm trying to figure out how to take all the values of the players and display the max by name. I have each position figured out but can't seem how to get excel to show me the best overall value by name.

    P.S. First Post
    Thanks for the help!

  2. #2
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Re: Fantasy Football Help!

    Probably an easier way...but try this...
    Attached Files Attached Files

  3. #3
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Fantasy Football Help!

    If the players are all ranked first to last - so all #1 at row 27 - then in G3 you could just use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by Tsjallie; 08-12-2014 at 04:35 PM.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ 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. Fantasy Football standings
    By jadubuque in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2007, 06:01 PM
  2. Fantasy Football & Excel VBA
    By A Mad Doberman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2006, 11:00 AM
  3. [SOLVED] Fantasy Football
    By tuggers in forum Excel General
    Replies: 0
    Last Post: 04-19-2006, 02:35 AM
  4. Fantasy Football
    By dibster in forum Excel General
    Replies: 1
    Last Post: 07-09-2005, 03:05 AM
  5. Fantasy Football
    By dibster in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 07-08-2005, 04:59 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