+ Reply to Thread
Results 1 to 12 of 12

Team standings

  1. 09-17-2009, 02:55 PM #1
    sucosam
    sucosam is offline
    Registered User
    Join Date
    09-17-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Team standings

    Hi there, I have a list of nine teams from B13:B21 with Wins in column C, Losses in Column D, Ties in Column E. Pts are in Column F (all of these run row 13 down to 21). The team listed in B13 has a cell name of One in the Name Box, team in B14 has a cell name of Two, etc up to Nine. The pts total for each team is also named, so F13 is called ptsone and has a current value of 8. F14 is called ptstwo and has a value of 10, etc.
    What I'm trying to do is in a different area of the spreadsheet put a formula that will compare the pts values and then list the team standings based on those points. I was using nested IF statements, but have had no luck so far. Can anyone give me some tips on this request? Thx
    Last edited by sucosam; 09-18-2009 at 12:06 PM.
    Reply With QuoteRegister To Reply
  2. 09-17-2009, 03:21 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Team standings

    Hi SucoSam, welcome to the forum.

    Click GO ADVANCED and use the paperclip icon to post up your workbook. Help us see what you want, put in the desired results manually and we'll help from there.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 09-17-2009, 03:27 PM #3
    sucosam
    sucosam is offline
    Registered User
    Join Date
    09-17-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Team standings

    Ok, think I got it uploaded. It's pretty simple as far as I can see, but I can't seem to get the right formatting in the sort the teams based on pts. Thanks again.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-17-2009, 04:08 PM #4
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Team standings

    Perhaps like this:
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 09-17-2009, 04:32 PM #5
    contaminated
    contaminated is offline
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Team standings

    Hi
    another option is

    Please Login or Register  to view this content.
    Nice way. I picked it up from DonkeyOte
    See file plz
    Attached Files Attached Files
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev
    Baku, Azerbaijan
    Reply With QuoteRegister To Reply
  6. 09-17-2009, 04:34 PM #6
    sucosam
    sucosam is offline
    Registered User
    Join Date
    09-17-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Team standings

    Thank to you both. I will check these out and see which works best for my purposes. I appreciate your time.
    Reply With QuoteRegister To Reply
  7. 09-17-2009, 07:30 PM #7
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Team standings

    If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


    (Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
    Reply With QuoteRegister To Reply
  8. 09-18-2009, 12:03 PM #8
    sucosam
    sucosam is offline
    Registered User
    Join Date
    09-17-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Team standings

    I have clicked the scales for both of your responses. Both solutions gave me what I needed, and in fact, I took part of both and put them into one sheet. Thx again for this. I will mark it as solved.
    Reply With QuoteRegister To Reply
  9. 05-15-2013, 02:31 AM #9
    amanek
    amanek is offline
    Registered User
    Join Date
    05-15-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Team standings

    Just joined and just wanted to say this was extremely helpful!!!
    Reply With QuoteRegister To Reply
  10. 05-15-2013, 04:06 AM #10
    amanek
    amanek is offline
    Registered User
    Join Date
    05-15-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Team standings

    Okay sorry - I spoke too soon... LoL... Here is the obstacle I have found... Was hoping someone with some experience could either help me or give me some advice on how to make this more simple cuz I think I've complicated it considerably. I'm an armature clearly - as it took me about 45 minutes to figure out how to Paste Special to get the standing/etc to work.

    Here's what I can't figure out:

    1) How to get rid of the Ties from the standings (cuz it's baseball we don't have any tie games - I'll live with it if it's complicated tho.)
    2) How can I calculate Runs For/ Runs Against / +/- run's in a simple way. What I'd like to do is imput the score once and have it record somehow but the way I have it set up makes that impossible (I think)... I just can't for the life of me figure it out without actually going in there and typing it in each week... Which I guess would be fine...
    3) When two teams have the exact same record, is there a way to adjust the formula to take the +/- as the tiebreaker and rank teams accordingly?


    Ahhhhh... Sorry so back to the 45 minutes to figure out how to paste the standings from sheet 2 into sheet 1... What a mess... I "paste special" and paste "Values & Number Format" and only just realized that I've lost the formula and when I make changes nothing happens to the standing... What am I supposed to paste (Sheet 2 to Sheet 1)

    Thanks a lot for any help/advice you might be able to provide... AD Softball League Schedule & Results - May%2FJuly 2013.xlsx
    Reply With QuoteRegister To Reply
  11. 05-15-2013, 04:11 AM #11
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Team standings

    amanek,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  12. 05-15-2013, 04:26 AM #12
    amanek
    amanek is offline
    Registered User
    Join Date
    05-15-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Team standings

    sorry didn't know - On it
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1