Page 4 of 4 FirstFirst ... 2 3 4
Results 31 to 37 of 37

Thread: Help required for League Table data entry

  1. #31


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

    Hello again!

    Just entering the results from week 3 into my new table and everything is fine till I try and sort the table. I select everything from C4-AA53 and then click the Sort/Filter button and select Custom Sort on Column C - Values - High to Low. This should put the points winner to the top of the table but I get an error that says "the operation requires the merged cells to be identically sized". I've tried resizing a lot of the cells but still get this error. I don't suppose it's a big issue but I can't find the problem!

    Season 11 Game 3.xlsx

    I was also wondering if this is the best way to sort the data each time? Is there a way to automate it so that as soon I've entered the scores I can run a macro or something to do this?

    Cheers,

    Brian.

  2. #32
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Hi Brian. Basically this is the reason you never merge cells, but instead use the 'Center Across Selection' option and/or clever formatting to just make it look like cells are merged.

    I'll fix up your worksheet for you, but this means that when you get down here the first two rounds are on you!

  3. #33
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    On your merge issue, read this:
    http://datapigtechnologies.com/blog/...e-center-icon/

    In regards to the sort, I've added an autofilter, which mean you can just click on the down arrow in column C and sort ascending. Sure, can automate if required. See attached.Season 11 Game 3.xlsx
    Last edited by JeffreyWeir; 2013-06-25 at 11:12 AM.

  4. #34
    Definitely:-)

  5. #35
    Hi Jeff,

    Doing that has caused the players ranking (column B) to be sorted as well. I was trying to see how to lock these values so that they're not moved with the rest of the data but have only found the "format cells-protection-locked" option and that's already selected. Is there a way to stop these moving.

  6. #36
    Don't worry Jeff, I've used Centre Across Selection to replace all the Merged Cells and reverted to the old filter method. I read the link you sent and will try to avoid the Merge option in future!

  7. #37
    Hi Jeff,

    I was wondering if you could just help tweak my table a little. The league I run has been growing and we raised the maximum number of players on any given night from 27 to 30 so I have had to adjust points allocation and payout structure. I changed the formula that calculates the points myself and that's all OK and I've added 5th place prize money to the look up table and given 5th Place it's own row at the bottom of the results table. I added conditional formatting so that the relevant cells are turned grey but changing the table on the right (the salmon coloured one) to add the prize money for 5th to the "Earnt" column is still beyond me. Would it be possible for you to look at that for me?

    Hope all is well in New Zealand.

    Many thanks,

    Brian.
    Attached Files Attached Files

Page 4 of 4 FirstFirst ... 2 3 4

Posting Permissions

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