+ Reply to Thread
Results 1 to 3 of 3

Index Match for my Baseball Spreadsheet?

  1. #1
    Registered User
    Join Date
    02-17-2012
    Location
    Illinois
    MS-Off Ver
    2011
    Posts
    17

    Index Match for my Baseball Spreadsheet?

    Hi, I have a simple (probably for most of you) excel question on index/match.
    I'm close with the formula but I only want each last name listed once. Not sure what adjustment needs to be done, or if I should use something other than index/match?
    There are two tabs. I want the last name of each player to auto populate the roster tab for each team.

    https://docs.google.com/spreadsheets...it?usp=sharing

    You can comment right on the document or here. Thanks!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Index Match for my Baseball Spreadsheet?

    In cell A2 of Roster, array-enter (enter using Ctrl-Shift-Enter) this formula

    =IFERROR(INDEX('Player List'!$B:$B,SMALL(IF('Player List'!$A$2:$A$15=A$1,ROW('Player List'!$A$2:$A$15)),ROW(A1))),"")

    and copy across, then down until all columns return ""

    I'm not sure if that will work in Google Sheets or not - but it will in Excel.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    02-17-2012
    Location
    Illinois
    MS-Off Ver
    2011
    Posts
    17

    Re: Index Match for my Baseball Spreadsheet?

    Solved thanks!

+ 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. Replies: 3
    Last Post: 02-17-2016, 10:04 AM
  2. Need Solution With Fantasy Baseball Spreadsheet
    By supdawg1985 in forum Excel General
    Replies: 7
    Last Post: 04-13-2015, 02:42 AM
  3. Index and Match or something else for this spreadsheet?
    By jondrasek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2013, 10:40 AM
  4. Show baseball standings (and more) online from spreadsheet
    By jakedonahue in forum Excel General
    Replies: 0
    Last Post: 04-04-2013, 03:20 PM
  5. creating Fantasy Baseball Spreadsheet
    By deadmanramsey in forum Excel General
    Replies: 14
    Last Post: 03-23-2012, 10:47 PM
  6. Fantasy Baseball Spreadsheet
    By jed_vii in forum Excel General
    Replies: 6
    Last Post: 05-22-2008, 12:03 PM
  7. [SOLVED] baseball Statistics spreadsheet
    By fkoskotas in forum Excel General
    Replies: 3
    Last Post: 05-02-2006, 02:00 PM

Tags for this Thread

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