Page 3 of 4 FirstFirst 1 2 3 4 LastLast
Results 21 to 30 of 37

Thread: Help required for League Table data entry

  1. #21
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Okay. So apart from that 680 being applied to blanks, are the correct amounts being applied to the correct people?

  2. #22
    Yep, all is fine bar that.

  3. #23
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Okay, I'll take a look.

  4. #24
    Many thanks for your efforts today NBVC and Jeffrey. I have to sleep now, it's 1.30am here and I have to be up early. I'll get back to you tomorrow after work though.

    All the best,

    Brian.
    Last edited by Brian Thomas; 2013-06-19 at 01:42 AM.

  5. #25
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    1:30am is prime poker playing time.
    Here's the cause of the problem:
    The formula in cell AC4 is hard coded to refer to your initial table that only had 18 rows, and ran from $H$4:$AA$21.:
    Code:
    =IFERROR(IF(INDEX($H4:$AA4,MATCH(AC$2,$H$2:$AA$2,0)+1)>=LARGE(INDEX($H$4:$AA$21,0,MATCH(AC$2,$H$2:$AA$2,0)+1),4),LARGE(INDEX($H$55:$AA$58,0,MATCH(AC$2,$H$2:$AA$2,0)),COUNTIF(INDEX($H$4:$AA$21,0,MATCH(AC$2,$H$2:$AA$2,0)+1),">="&INDEX($H4:$AA4,MATCH(AC$2,$H$2:$AA$2,0)+1))),0),"-")
    If you adjust this reference to point to the increased table size of $H$4:$AA$53, it should work:
    Code:
    =IFERROR(IF(INDEX($H4:$AA4,MATCH(AC$2,$H$2:$AA$2,0)+1)>=LARGE(INDEX($H$4:$AA$53,0,MATCH(AC$2,$H$2:$AA$2,0)+1),4),LARGE(INDEX($H$55:$AA$58,0,MATCH(AC$2,$H$2:$AA$2,0)),COUNTIF(INDEX($H$4:$AA$53,0,MATCH(AC$2,$H$2:$AA$2,0)+1),">="&INDEX($H4:$AA4,MATCH(AC$2,$H$2:$AA$2,0)+1))),0),"-")
    See attached.
    Table_02e.xlsx

  6. #26
    Hi Jeff,

    Yes 1.30am definitely good time to be playing poker but I don't play online very much any more. I much prefer playing "live" and enjoy the banter that comes with that.

    The table is looking great thank you very much. There's just a couple of little tweeks to the design that I want to make and it'll be ready to use.

    I really do appreciate the help and will be good to my word and send you a virtual bottle of wine via PayPal if you let me have your email address. You can send details to admin@oldtownpoker.co.uk, as can NBVC.

    Many thanks guys,

    Brian.

  7. #27
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,512
    Articles
    0
    Excel Version
    Excel 2016
    No worries Brian. I appreciate the offer, but I am here as a volunteer giving my help out for free. The "thanks" is enough payment for me, really.


  8. #28
    Hi NBVC,

    Your help has made managing the results of my league much, much easier and I'm grateful. It's not something I could have attempted on my own.
    When the table is 100% finished I'll post it here again in case anyone following this thread (or looking at it in the future) can maybe benefit from it.

    Cheers,

    Brian.

  9. #29
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Tell you what, Brian. Next time you're in Wellington, New Zealand I'll take you to my favorite pub, and the first round can be on you!

  10. #30
    That's a deal.

    All the best,

    Brian.

Page 3 of 4 FirstFirst 1 2 3 4 LastLast

Posting Permissions

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