Autofilling?
Autofilling?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Autofilling?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have built a spreadsheet for a Masters Golf pool. I have 34 teams of 13 players. How do I apply a filter or something that will fill in the scores for all of the teams?
    There are a total of 54 players - and I only want to enter their scores once. I want the spreadsheet to recognize "woods" is cells b2 and e2 and automatically drop his score "69" into cels C2 and F2. I have set up all of the 54 players names and scores on a separate tab.

    Any help would be appreciated.

    Thank you
    New User

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    this sounds like a job for vlookup (for one score) or sumif (for summing several scores).

    See the help file for details, but an simplified vlookup goes something like this
    Vlookup("A",$A$1:$B$10,2,0)
    where
    A is what you want to looks up (Woods)
    A1:B10 is the range your score is entered. column A must contain "Woods" and column B has the corresponding score
    2 is the column you want the value from
    0 just tells excel you want an exact match.

    Simplified Sumif is
    sumif($A$1:$a$10,"A",$b1:$B$10)
    This says will return the values in B1-B10 for the values in a1:A10 that equal A (woods)

    Good luck

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com