# Thread: Help required for League Table data entry

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

2. Yep, all is fine bar that.

3. Okay, I'll take a look.

4. 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.

5. 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. 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. 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. 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. 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. That's a deal.

All the best,

Brian.

Page 3 of 4 First 1 2 3 4 Last

#### Posting Permissions

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