Results 1 to 1 of 1

Excel 2008 : show multiple values with INDEX function

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Annandale, VA
    MS-Off Ver
    Excel 2003
    Posts
    1

    show multiple values with INDEX function

    Hey everyone,

    So im sure this is an easy fix, as I really need help on editing a spreadsheet for my fantasy football league...

    I have created a google docs spreadsheet for my Fantasy Football League so owners can not only view all-time stats, but also for them to edit any contact information they wish to share with others in the league.

    Here's the problem.

    I have been using an =INDEX function to reference statistics, for example, "Team A" may have the most amount wins totaling 25, so the function shows the team name as opposed to a number.

    I am encountering future problems on what if there is more than one team with the same amount of wins as another (a tie), and is there a way I can reflect that using Excel automatically? Im trying to think of ways to do this and doing some research but I thought it maybe a good idea to throw it out there for anyone that may have an idea.

    Also,

    Last little itty-bitty problem,

    I have been indexing the problem above to just show the names instead of the values, is there a way to possibly do both? I know this may as well be a easy fix but I am struggling to figure it out. I have attached the file below for anyone who wishes to look and see if they can try to figure it out.

    Lastly,

    Thank you for all of your time guys!! I appreciate it!

    PS - The Sheet I am referencing with the problem is called "All-Time Stats"
    Attached Files Attached Files
    Last edited by Yannakos; 10-25-2011 at 04:03 PM. Reason: Fixed Thread Title...

Thread Information

Users Browsing this Thread

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

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