+ Reply to Thread
Results 1 to 97 of 97

Keeping Track of high game bowling scores

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Keeping Track of high game bowling scores

    Trying to keep track of high games to post over the lanes,did a example layout but need help in how to sort out the data.

    Would it be possible too have two names in a textbox if there was a tie on a lane?
    Thanks Z
    Attached Files Attached Files
    Last edited by zplugger; 09-10-2016 at 01:43 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Keeping Track of high game bowling scores

    If you remove the text boxes and then use this formula in the first one and modify for the remaining you should be able to get the highest score

    =MAX(IF($B$14:$B$63=1,$C$14:$C$63)) and make sure that you enter this by press Ctrl + Shift + Enter after typing this formula, instead of just pressing Enter.

    This will place curly brackets {} around the formula and make it any array formula.

    I am not sure if you can place more than one name without using a VBA solution and I am not sure of how to do that.
    Attached Files Attached Files
    Last edited by alansidman; 08-27-2016 at 05:27 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks Alansidman, is there a way to have the name too? Guess this is going to be a long process, not even sure if all is possible.

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Fix the array to read top scores, any idea's how to get the name with the score?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Alansidman made me a code to find the highest game per lane,can I use vlookup to make a list of all games per lane with highest always first? I'm not
    even sure if this project can be done,seems like excel can do just about anything with helper columns.

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Keeping Track of high game bowling scores

    With those buttons you can have nothing but the problems.

    Here, try this in A6:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Keeping Track of high game bowling scores

    I decided to jump in on this one.

    The first thing I did was to change the data to Excel tables so there is a men’s table and a women’s table. Tables are so much easier to work with and reference in formulas.

    Then I made a helper sheet (Sheet2). This sheet has a lot of array formulas.
    Column A is the lane
    Column B is the maximum score for that lane
    Column C is the number of maximum scores for the lane (I rigged the data to have a tie on lane 3)
    Column D is the row on which the first high score occurs
    Columns E though I are the rows on where the first tie, second tie, etc. occur. Mostly these are #NUM errors because there aren’t a lot of ties.
    Columns J though O look up the names associated with the high scores.
    Column P is a concatenation of the names with the high scores.

    I dropped the text boxes and replaced them with “regular” text boxes from the Insert Ribbon. I ran out of real estate, so I rearranged the layout.

    I set the values of the text boxes to the values computed in Column P.

    Finally, in a gesture of sexism, I colored the men’s data in blue and the women’s data in pink.

    What's best is that there is no VB involved at all. This is all straight Excel.

    And last, I’m glad I’m not bowling on this league. These scores are tough to beat.

    P.S. I only did the men. You can set up a parallel system for the women's scores.
    Attached Files Attached Files
    Last edited by dflak; 09-02-2016 at 03:59 PM. Reason: Add PS
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Keeping Track of high game bowling scores

    Hey zplugger,

    I agree with Zbor that VBA is way to hard to do this problem. See my attached where I've done all the work in 3 possible Pivot Tables. Click on the filters to filter a single lane or use the lanes as columns heads. Learn a little about Pivots and you won't need VBA.

    Bowling High game per lane Pivot.xlsm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  9. #9
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Wow getting a lot closer zbor, Thank You. Now I need to figure a way so you can only have your name on one lane at a time,say you have 300 on lane 1 and a 299 on lane 5 then it will only show your high game.So lane 5 would show who had second highest game. I will work on setting up all the lanes with your code and post example back.
    Again Thank You

  10. #10
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks MarvinP, taking a look now,how do you refresh a table

  11. #11
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Keeping Track of high game bowling scores


  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Without any bells or whistles, textboxes, labels,vba and so on, I have redone the first two Columns "Lanes 1 and 2" for you as an example. Please do let me know if you approve.

    Kind Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  13. #13
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Attached please find a sample Workbook of the Final results.

    Regards.
    Attached Files Attached Files

  14. #14
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Hello Everyone, Got a couple good suggestions for this project. This example was made by Winon and needs a couple tweaks if possible. I added a couple shapes with text explaining the tweaks needed,not even sure the tweaks can be done with all the data changing all the time.
    Attached Files Attached Files

  15. #15
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Thank you for the feedback.

    Since you require a bit of automation, I had to include some VBA Coding.

    As soon as you have amended the Players in the correct lanes, the results will adjust accordingly.

    Please see the changes in the attached Workbook.

    Regards.
    Attached Files Attached Files
    Last edited by Winon; 09-09-2016 at 02:18 PM.

  16. #16
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks Winon, seems to be a problem with some of the scores per lane? For example lane 6 has wrong data in example. I looked over code and can't find the problem. Is there a quick way to unhide the code columns?

  17. #17
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you for the feedback zplugger.

    Is there a quick way to unhide the code columns?
    Yes there is, but it should not be advocated since the formulas could be compromised.

    Regards.
    Last edited by Winon; 09-10-2016 at 03:09 PM. Reason: Removed wrong Workbook

  18. #18
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks for the challenge Winon,will start working on it. Might take this old guy some time but will give it a go.

    Thanks again for all your help, Forum is lucky too have guy's like you

  19. #19
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Old Man zplugger,

    Might take this old guy some time but will give it a go.
    You are no older than me "Old Man", and I still feel young!

    Regards "Gramps".

  20. #20
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi "Old Guy",

    Speaking of which, maybe I should admit that same applies to me, since I erred in sending you the "Test" Workbook, instead of the "Final" Book.

    Below is the correct Book. With the three tier rankings sorted out as well. If a Player appears on the List with a Lane Number and no Score yet, it displays the Player in his/her Lane with a zero Score.

    I shall remove the "Test" Book from Post#17.

    Here is a challenge for you!

    Try to catch me out on the revised attached Workbook, or default me in any way!

    Enjoy!
    Attached Files Attached Files

  21. #21
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks will have another look,one question for anyone if I may. Trying to password the workbook and having trouble with the removing duplicates when protected. Thinking its got something to do with the array? can I add code to remove password when the button is pushed the protect the book again after dup's are removed.I have all the ranges set to unprotected.
    Another thing is when a new small name is added it does not go below another name in lane,go beside it when it should be on its own line. This thing is almost done and I hope other people can use the coding ideas from Winon.
    Please Login or Register  to view this content.
    Last edited by zplugger; 09-10-2016 at 03:47 PM.

  22. #22
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Do you mean to Password Protect the Workbook or just the Sheet?

    If it is just the Sheet, you could use the Code below:

    Please Login or Register  to view this content.
    Repeat this in every Sub of the Code.

  23. #23
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Sorry zplugger,

    Another thing is when a new small name is added it does not go below another name in lane,go beside it when it should be on its own line.
    I have missed this, but here is the solution:

    For the Men in Lane 1 Paste this Formula in the "Box" with the three names, and then Copy and Paste to all the other "Boxes".

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Do the same for Women, also starting with the first "Box" with Formula below;

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I have all the ranges set to unprotected.
    Maybe you should set it back to Protected(Locked), since we are only working in Range A14:C1000 and Range G14:i1000, and the above Code Range Locked = False takes Care of that.

    Hope that solves your issue/s.

    Kind Regards.
    Last edited by Winon; 09-10-2016 at 05:00 PM. Reason: Added more info on Range Locked and Corrected Formulas.

  24. #24
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi zplugger,

    I have corrected the formulas for Men and Women in Post#23.

    Sorry for the slip.

  25. #25
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks Winon, Have a Great Weekend and again Thank You for all your hard work. I will put the new codes in and test it out. I hope I don't have any
    more questions for a while.

  26. #26
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi zplugger,

    You are welcome my friend. Thank you for your patience with me.

    May you also enjoy a Great Weekend.

    Kind Regards.

  27. #27
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    On second thoughts, I have decided to try and help in making your Weekend Great!

    Check out this freebie attached revised Workbook, with all the latest required adjustments. All done.

    All you have to do is to first Click on Unprotect Sheet, go to the VBE and search for all Passwords in all of the Code, and enter your password between the quotes.

    This will save you a good piece of other adjustments, so that you can enjoy what is left for the weekend.

    Enjoy.
    Attached Files Attached Files

  28. #28
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Ran into small problem that I can't solve,when removing duplicates it also removes any cell formatting.Would like to keep all formatting to the cells. It also changing Cell Protection too.
    Thank You

    Please Login or Register  to view this content.
    Last edited by zplugger; 09-14-2016 at 11:56 AM.

  29. #29
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi zplugger,

    removing duplicates also removes any cell formatting...
    would that be on the last Workbook I have Posted, and what kind of Formatting would be involved? I Find it very peculiar and strange!

    Kind Regards.

  30. #30
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Hello Winon
    What I did was put a bolder around the name,lane score and set protection to none.All is find until I clear a duplicate,bolder around cell goes away and cell is locked.

  31. #31
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you zplugger,

    Would that be on the last Workbook I have Posted?

  32. #32
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Yes just tested with your last workbook

  33. #33
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you zplugger,

    I have done the same as what you have said, and I cannot replicate your problem. Have you perhaps Protected the Workbook Content itself as well?

    Maybe it would be a better idea if you could send me your Workbook again, with all the relevant Passwords, for me to have a look at.

    I would love to see what you have messed up again. LOL
    Last edited by Winon; 09-14-2016 at 12:46 PM.

  34. #34
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks Winon
    You are very correct about problem,I download the book again and cannot replicate problem.So this means I have done something wrong,Please give me a couple days to try and
    figure it out,it will be good learning for me.I did save as a XLSM file but that should not be problem.Thanks for looking and I will let you know what I find,here comes my sleeping problem again.LOL

  35. #35
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Been testing Winon, here is what I finding. If I take and Highlight all Mens names,lanes,scores and remove content it does it.Now if I format the bolders and make a duplicate it takes away the formatting.Got something to do with clearing all example names?

  36. #36
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    I am testing same, please allow me a moment.

  37. #37
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Sorry zplugger, but please don't make your problem mine!

    Just jerking your chain, gimme a day or so, and I will have it Solved. In the meantime, when you do want to make such changes, please just make sure the Sheet is always UnProtected.

    'Till later then.

  38. #38
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    O.K. zplugger,

    Together we can put this to bed, but first we have to agree on a few matters.

    1.
    If I take and Highlight all Men's names,lanes,scores and remove content it does it.Now if I format the bolders and make a duplicate it takes away the formatting.Got something to do with clearing all example names?
    This is a double/triple "barrel" question/statement, which I need to clarify with you.

    a. How do you "take and Highlight all Men's names,lanes,scores and remove content"? Do you use the "Delete" or the "Clear" Button?

    b. "Now if I format the bolders and make a duplicate it takes away the formatting", this will only happen if you have Protected the Workbook. Do you have the Workbook Protected?

    c. "and make a duplicate it takes away the formatting". How do you go about making a duplicate and where do you do that, on a different Sheet, or Columns on the same Sheet?
    NOTE: If you could show me how you want the Final "Bolders" and "Text", etc. I could provide for it in the Code to prevent it from not responding likewise.

    Looking forward to your response.

  39. #39
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Right now I clear content,All I need is a way to clear all names,lanes,scores at end of year to start next year.
    To make a duplicate I just add the name.lane score in twice,when removing dup I lose formatting.
    I did not have VBA protected.

    Hope this helps,everything is going bad.(TV QUIT) LOL

  40. #40
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    How do you "take and Highlight all Men's names,lanes,scores and remove content"? Do you use the "Delete" or the "Clear" Button?

    Are you using Clear?

    I did not have VBA protected. What I asked is "Do you have the Workbook Protected?" This is different from Sheet protection.

  41. #41
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Yes Clear to remove data
    No workbook Protection

  42. #42
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you for the feedback Bugger, oops I mean zplugger,LOL

    Please NEVER use "Clear" for the Men's or Women's Sections, as "Clear" removes everything including Formats.

    Please may I beg you to rather highlight the range/s and use the "Delete" Button.

    Do try it and let me know if that solves your problem.

    Hope it works for you now my Friend!

  43. #43
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Still not getting this,with delete button in ribbon same thing happens. Is there a form button I can add with a code to delete only the contents in the range?

  44. #44
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi my Friend,

    Is there a form button I can add with a code to delete only the contents in the range?
    That is possible yes, but you should use the "Delete" Button on the Keyboard only, and nothing in the Ribbon as such.

    Please try it that way, and let me know if the problem persists.

    Thank you.

  45. #45
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    I did the keyboard and still same thing,guess I can't have bolder around each cell. Don't think I ever noticed this before.For example I put a bolder around first 50 names in list and create a dup and remove the dup I lose all the formatting.

  46. #46
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi my Friend,

    I put a bolder around first 50 names in list and create a dup and remove the dup I lose all the formatting.
    Where and how do you create the "Dup"

  47. #47
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Revised sample Workbook attached.

    Do what you like, use the "Clear" Button, Create a Copy(Sample on Sheet2), make your changes and Paste it as it appears(Without Formats), back to Sheet1, and see what happens.

    Regards.

  48. #48
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks Winon
    I added code to the Do It macro to format the bolder back, Wow I get to see how you did it.Learning something new daily.Thanks for trying something new for me,you
    have been so much help.
    Z

  49. #49
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi Z,

    Thank you for the feedback.

    I added code to the Do It macro to format the bolder back,....
    That is totally unnecessary, since the Delete Dups Code in the Do It Macro can NEVER remove Formats. It places an extra burden on that Macro, and I would suggest you remove it, and see for yourself.

    Regards.

  50. #50
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Ok I will remove,when I ran the Do it Macro that is when I lost formatting.

  51. #51
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Does it do the same on my latest uploaded Workbook?

  52. #52
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    No, last one works Great. Thanks

  53. #53
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    I am glad to hear your problem seem to be Solved with the last Workbook. It is really a pleasure working with someone like yourself who knows what he wants, and is so keen to learn!

    Thank you for your patience and for the "Rep", it is much appreciated.

    Kind regards.

    W

  54. #54
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi zplugger,

    Maybe you would like this revised attached Workbook better?

    Kind Regards.
    Last edited by Winon; 09-16-2016 at 11:19 PM.

  55. #55
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Here is a challenge Winon, If a name shows up twice in the top row the cell turns yellow. So if Efren*Oglesby has high game on lane 1 and has high game on lane 6 both cells would be yellow.But if Efren*Oglesby had the second highest game on lane 6 nothing would happen. I Think for this to work we would have to use the names in BI to BW.

  56. #56
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    Do you call it a challenge? Please

    However, you are correct with your comment;

    I Think for this to work we would have to use the names in BI to BW.
    I "Hate" you for taking me to task. but love it!

    It needed to change a few things, but as you will see in the revised attached Workbook, I hope it satisfies your latest requirement.

    Best Regards.
    Attached Files Attached Files

  57. #57
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Like the way you think,I never of tried that way. You amaze me on you knowledge,you solution should work perfect.
    z

  58. #58
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you for the kind words zplugger,

    It is people like you, and others on this great Forum, making it worth my while to still hang around, 'till Higher Powers call on me for whatever awaits.

    Greetings!

  59. #59
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    When they have your label Forum Gura,they weren't kidding. Seems like any question I have you will answer,(Thank You). Ok you found a way to show if a person is tied for first place,is there a way to put that name in the yellow cell.I know this won't be easy,better sleep on it for another day my friend.

  60. #60
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you my Friend, it is long past my sleeping time, but don't worry, I shall do that for you, A.S.A.P,

    Good Night, it is already almost 2 am Sunday her by us.

    Hope you understand.

  61. #61
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi zpligger,

    I could nor fall asleep, since your latest request Kept on Bugging me.

    So here we go, with the new revised attached Workbook.

    Hope it Solves your latest request.

    Bach=k to catch up on a lot of lost sleep(Rest)

    You guys make me "Sick" LOL: just Joking:

    HTh,

    Best Regards.

  62. #62
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    I just don't understand how one person can be so good at this,works perfect.Right now when a person is in first place on two lanes I will pick his lower score and add a X in front of it to remove him from that lane.You can only have your name in first place on one lane at a time,any clever ideas instead of the X to do this? This is only part a human has to figure out,don't think code would be able to make this decision.

  63. #63
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello Mr. Z,

    I believe we are not exactly on the same page!

    Pick up your magnifying glass, and READ the Top Line of Sheet1, which states "Final Results". Nothing wrong with having a player in more than 1, 2 or 3 Lanes or more. It is a summary of the Final Outcome.

    Now please Check Sheet2, which does not allow Players to be duplicated on more than one Lane. Sheet2 is named "Running Results", for a lack of a better description. You cannot ski with a boat fitted with an egg beater.

    O.K. Z, enough revving you up, as you have said before, "you are an Oooold Man". LOL,

    My Friend, please see if the revised attached Workbook suits you better.

    Kind Regards.

  64. #64
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Morning Winon
    Sheet1 runs perfect,it keeps track of all scores entered.This is what I needed,but the bowling center will only put a name on one lane at a time.So that is why I put a x in front of a score if a player is at top of list more then once.Putting the x solves my problem,when a player has two high scores on different lanes he must go to his highest lane and the other would show who was second. Hope this makes sense,what you have done works perfect.One thing I notice when sorting from lane,player,score, the player will not show dup's. Will play with the code for a fix,must be something little.

    Thanks again for all your help (Must be late there)

  65. #65
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    As I have said, the first Sheet is a summary of the final results.

    ...the bowling center will only put a name on one lane at a time
    That is where they should use the dynamic, real time, second Sheet named "Running Results". No need for using a "x" on that Sheet.

    W

  66. #66
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Sorry for not explaining better Winon, this is a seasonal high game board. So the dynamic sheet does not help,but the code work will be useful. I will make what we have work,Thank You.

  67. #67
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you for the clarification zplugger,

    It requires at least two questions to be explained.

    1. If there id a Tie in 1st or 2nd Place, what criteria to you use to "discriminate" against the other player when you use the "X"?

    2. What is the duration of a typical Bowling Season, and how many games are played during that period?

    Kind Regards.

  68. #68
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Morning Winon
    Very good questions,If a tie for first they will post both names(Does not happen often)
    Season last about 32 weeks,but this can not be a factor,The name board is for all leagues in bowling center,so a anybody could get their name posted if its the high game.Thats
    where I'm using the X to control the High Game list per lane.Not sure excel could make that decision on who is first per lane. If Joe Smith bowl a 288 on lane 3 and had a 292 on lane 7 then he would only be in first on lane7. So lane 3 would show who and second highest came as first place.You have done enough my friend on this,I can use the X
    Z

  69. #69
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Thank you for the feedback zplugger, I shall now resign from this project, unless you stumble upon something which requires attention, feel free to let me know.

    Kind regards,

    W

  70. #70
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Hello again Winon
    In post #61 I can't fix the bug. Been trying for hours with no luck,here is what I get.
    If I add a name to list as a dup for testing it does not always show as a dup.If I change back and forth between the sort buttons it might kick in
    and show as dup? Should't this dup show up on any of the sorts? Was thinking it might be because a row was added for women's names,but looked at code and I think its right.Did not see this happening in our early versions. Please have look when you get time,I will keep pegging away at it. Its a good learning excise for me.

  71. #71
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    In post #61 I can't fix the bug.
    Sorry Z, but that is not a "Bug" for the Code was written to Compare Name, Lane and Score. If all of that was pasted at the Bottom of the List or anywhere else, it will definitely show as a "Dup".

    I had to use those three criteria, Name, Lane and Score, otherwise the program would be cluttered with "Dups", which would be False!

    Trusting that you get the concept, I am looking forward to any other clarifications.

    Kind Regards.

  72. #72
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Here is what I found Windon with the file in post#61
    1- If you click the buttons in this order Sort Men-Sort Scores-Sort Lanes you get different results? Watch the changes on lanes above
    Sort Men Manuel Wickman,Efren Oglesby,Esteban Cookson
    Sort Scores Manuel Wickman,Efren Oglesby,Esteban Cookson
    Sort Lanes Manuel Wickman,Efren Oglesby,Trent Presti (should't this be Manuel Wickman,Efren Oglesby,Esteban Cookson)

    Now the problem is found,thinking because no score in some of lanes it does not sort right. So if I put a 0 in the empty cells all is well,this will probably never happen. For a fail safe
    can we add a message box telling us there is a empty score on a lane,we could add this to the Lane and score buttons. I'm sure you will come up with a better way.
    So in conclusion it was My Data Fault and not your code.
    Thinking I might sleep better tonight my friend.

  73. #73
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    For a fail safe can we add a message box telling us there is a empty score on a lane,we could add this to the Lane and score buttons
    No, personally I find repetitive MsgBoxes irritable, and would rather have the Code silently replace the Blank Scores with a Zero in the background!

    Please see if the revised attached sample Workbook suits you better. Again you will have to change the Password/s to your own choice.

    Regards.

  74. #74
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thank You Winon, May I ask a couple questions ?
    In many hours of testing this is what I don't understand,in the last workbook go to sort lanes and you will see Brock Darville is is first name in lane1. Now change his zero score to 300,then sort men.You will see the new entry on top but if you sort lanes again he is gone? Like when you sort lanes it does not pickup top name,if you look at lane 6 it makes changes too.


    Just noticed that if you delete mens data then womens data and reset format its all out of wack. Thanks (It the end of today,so rest my friend because tomorrow is new day.)
    Z
    Last edited by zplugger; 09-20-2016 at 03:54 PM.

  75. #75
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    No problem Z,

    Yes, I made a few mistakes, but hopefully have it sorted out in the Workbook below.

  76. #76
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Perfect, works like a charm.11:00 time for sleep my friend.O forgot you never sleep.LOL Going to play around with restore formats after data deleted,not quite right.Give me a hint where the
    sort problem was,sur it had to do with row be added?

  77. #77
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi Z,

    Give me a hint where the sort problem was, sure it had to do with row be added?
    Yes, you are correct, it involves quite complicated changes to formulas and Code, and it is easy to miss something!

    Restore Formats works fine in all aspects.

    Regards.

  78. #78
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    I have made the current Workbook work even better. To save you you the trouble of fixing your Password accordingly. please find a means of providing me with your Password, so that I can include it for you in the revised Workbook.

    Thank you.

  79. #79
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Looking forward to seeing the change,you have some great ideas.One thing I think needs address is when you enter a new name.Right now the after you enter name then lane it does a sort before you enter the score. I made a change to so that would not happen until score is filled in but with the ) being added it creates problem.Have a try and see what I mean,I think we are 99.9% finished with this. A lot of good code examples for future projects,Hope this will help other people on forum for learning.When I get time I will go over all the codes to understand what and how it doing.
    Z

  80. #80
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hello zplugger,

    You have a good eye, and I appreciate your positive feedback.

    Sorry to see you say all my hard work is only 99.9% good enough for you.

    In that case please find someone else that can do better.

    Gotcha!, just joking my friend.

    Please do let me know if you have any problems with the new attached Workbook.

    Kind Regards.

  81. #81
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Excellent work my friend,not sure but on my end when I delete both mens & womens data, form shrinks to almost nothing. Can't read anything?
    Last edited by zplugger; 09-21-2016 at 04:39 PM.

  82. #82
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi Z,

    What do you want to read if there is nothing?

  83. #83
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    The whole layout is like 3 inches wide
    Capture.JPG
    Last edited by zplugger; 09-21-2016 at 04:52 PM.

  84. #84
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Lets see its about 11:00 where your at and 5:00 here. Your getting to old for these hours,when I was younger I could stay up like you.I still have another clever idea if
    your up for the task,when a person is in first place on two lanes I want to be able to remove him from first but keep his score on lane. So if we did a double click on a selected cell it would put a X in from of his score,now it won't read that score.If the X is removed his score will be working again,but this is for tomorrow!!!!!!!!.
    Night

  85. #85
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Here you go, try the version below!

  86. #86
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Now that's what I'm talking about,You are the Master.(PERFECT) Now I will look at your changes.
    Z

  87. #87
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Whatever tickles your tummy, I am glad you approve so far.

    W

  88. #88
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Your going to hate me,some of the First place dups not working. For sure lanes 3,4,5,6,7,8 for women. Not sure about men yet. Same for men,kinda like finding whats wrong,not sure possible for me.LOL
    Last edited by zplugger; 09-21-2016 at 07:28 PM.

  89. #89
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    I saw that before you did, took me a while to find the problem, and eventually nailed it. The culprit, again to to with the added lines!

    there is another problem which is Excel related without a possible fix it seems, and that is when you sort the Scores for either Men or Women for the first time, you have to to Click on the "Sort Scores" for men and women twice, before it lists all the zeros if any at the top of the respective lists. I am sure you can live with that!

    Please let me know if it works for you now?

  90. #90
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    The zeros we will live with,something not picking dual first place ties.In last workbook yellow missing in lane 8. I think lanes 3,4,5,6,7,8 is not working foe men and women. Tackle this tomorrow or the sun will be coming up and you missed a nights sleep.

  91. #91
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Morning, got the problem with dual first place fixed.The problem started when I had you add the zero's,my bad idea. Lets drop that part in code,I'm sure a score will be
    added in. Sorry about causing that problem,Think all is well now,unless we can do the doubleclick on selected cell to add x in front of score.I will set up button to remove selected X and one to remove all x's in list.You have done a Excellent job on this Winon,your going to miss me aren't you. LOL

  92. #92
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Good afternoon zplugger,

    The problem started when I had you add the zero's,my bad idea. Lets drop that part in code
    That will also be a bad idea, since if you happen to have a blank Score, it will reflect in the corresponding lane as a Zero, if there are not already Three Players listed with scores greater than Zero. I am sure you don't want that either. Instead of filling out the blank Scores with a Zero, I have replaced it with an "X". You will see the benefit of that in the summary Boxes under the respective lanes.

    You now also have two extra Buttons, one to "jump" to the Bottom of the Men's List, and the other takes you back to the top of the same list, instead of having to scroll all the way up or down.

    To add an "X" to a Score you wish to hide, simply double click on that Score, and to remove the "X" from a Score, also just double Click on that Score again. Simple.

    ...your going to miss me aren't you
    Nah I don't think so, since I bet you a Coke and a Bun, that you will come knocking on my door soon enough!

    Stay in touch "Old Man".

    Kind Regards.
    Last edited by Winon; 09-22-2016 at 11:12 AM. Reason: Fixed formulas in Workbook.

  93. #93
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Thanks Winon, this was like a good book, but we read the final chapter and now all we have is memories.

    Thank's

  94. #94
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Hi Z,

    Thank you for the feedback my friend.

    There is a problem in the last Workbook I have Posted.

    Did you forget to clean your reading glasses? It is a typical "Old Man" syndrome!

    If there is only one Name in a "Box" on any "Lane" it shows that there is a tie for 2nd Place, what nonsense is that???

    I shall remove the Workbook in Post#92 and replace it, with mistakes taken care off. I expect you to scrutinize that Workbook, until you find a problem, otherwise I shall lose my temper and come and beat your Chickens to death. If you don't have Chickens, then you will just have to buy a dozen or so!!!

    Regards.

  95. #95
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    Sorry Winon,I have no chickens but will see if grandson will let me borrow his. Lol Since you asked LOL I think the double click is a good idea But I think it should be
    restricted to the score column only,what do you think? Its so hard to find fault in something you have done, Excellent work my friend. Been making few changesto the workbook, for exampl I add a pop-up calendar to add date in box to right score. 9/22 for example,does not take much room. Still testing so won't worry grandson about chickens yet.
    Z

  96. #96
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Keeping Track of high game bowling scores

    Here you go zplugger,

    I think the double click is a good idea But I think it should be restricted to the score column only
    Agreed. Here is your last update.

    Regards.

  97. #97
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Keeping Track of high game bowling scores

    As always Excellent work.This project has been like a crime scene,but the case is closed for good.The guilty one of
    all this hard work is Winon, I sentence him to a full night sleep.

    Can't Thank You enough
    Z

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Return two or more high scores of the same value.....
    By sandy.rogers in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-20-2012, 03:22 PM
  2. high scores and tiebreaker
    By odha in forum Excel General
    Replies: 3
    Last Post: 10-01-2009, 01:17 PM
  3. tracking the difference between two running scores in a game
    By radchillies in forum Excel General
    Replies: 4
    Last Post: 12-10-2008, 12:18 PM
  4. bowling scores
    By Cricket in forum Excel General
    Replies: 2
    Last Post: 02-19-2006, 12:00 AM
  5. [SOLVED] Formula Question:keep track of all my bowling scores
    By Chris in forum Excel General
    Replies: 1
    Last Post: 01-16-2006, 05:35 AM
  6. [SOLVED] Does anybody have a template to keep track of bowling avgs & hcp
    By CesarDLC in forum Excel General
    Replies: 0
    Last Post: 12-12-2005, 05:40 PM
  7. [SOLVED] Bowling Game
    By Roger King in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-13-2005, 08:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1