Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    thanks heaps guys. (Excel XP)

    Thankyou Steve andTony soooo.. much for your help regards my excel formula problem. Your the best. Cheers. Sylvie

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: thanks heaps guys. (Excel XP)

    I'm glad you appreciate the help by Steve and Tony. For next time: please post reactions to an existing thread in the thread itself (use the "Reply to this post" button), that makes it easier for other Loungers to understand what you are reacting to. Thanks <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: thanks heaps guys. (Excel XP)

    Sylvie:

    You're very welcome.

    For the future, rather than start a new thread, it is better to click on the reply button - see Help, Index 8 and attached screen shot.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: thanks heaps guys. (Excel XP)

    Sylvie:

    Didn't mean to labour the point. When I started my reply, Hans's post wasn't there. By the time I posted - there it was.

    Ain't that always the way!

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: thanks heaps guys. (Excel XP)

    I have tried your advice but cant get the result I am seeking. Will try explain myself a little better. This spread sheet is for junior rgby team.
    a3:a18 has their names. Week 1 Week 2
    b3:b18 has their scores = SUM(d3:AM3) A B C D etc.....
    b20 has the highest weekly score =MAX(b3:b18) peter 3 1pt 2pt 3pt
    c3:c18 has the name of the highest weekly player =IF(b3=$b$20,a3,"")
    Each week I enter their points into the appropriate week and the score in b3:b18 is updated. A new leader is displayed if his score is the highest also.
    NOW I need to apply a formula which will allow me to show the names of 2nd and 3rd highest scoring players in different coloured cells. I also have to keep in mind that there is a possibility that more than one player could have equal points. So I have to allow for multiple place settings. I hope you can understand what I am asking. I am still learning to drive this computer and find the language challenging. Thanks for your patience. Sylvie

  6. #6
    New Lounger
    Join Date
    Oct 2003
    Location
    Perth, Western Australia, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: thanks heaps guys. (Excel XP)

    I have just reviewed my last message and am disappointed to discover it has not appeared as organised as I thought I had written it. I sure hope you can make sense of it.
    D3:AM3 are split up into groups of three columns. Each group are where I enter the players poits each week. D-1 pt E- 2pts F - 3pts. ok.
    sorry, sorry, sorry.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: thanks heaps guys. (Excel XP)

    Perhaps you can attach a sample workbook, this will make it easier for whoever wants to have a go at it. The sample workbook doesn't need to have all the data, just enough to give an idea. It should be below 100 KB; it it's too large, put it into a zip file and attach that.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: thanks heaps guys. (Excel XP)

    You seem to have continued the discussion in the other thread. Having two active threads about the same subject is confusing, so I will lock this one.

    All further reactions in the thread starting at <post#=309259>post 309259</post#>, please. Thank you.

Posting Permissions

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