+ Reply to Thread
Results 1 to 1 of 1

Help With A Tally Sheet

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    San Mateo
    MS-Off Ver
    Excel 2016
    Posts
    16

    Help With A Tally Sheet

    I need some help in making a tally sheet for sporting picks and I want to tally the loses at the bottom. I figured out how to count the picks before the games are played which in column L is an example of 5.
    In column M the player picks all 5 games correctly and the result is 0 which is correct.
    In column N the player picks all 5 games wrong and the result is 0 and should be 5.
    In column O the player picks 2 games correctly and the result is 0 and should be 2

    What I had been doing is high lite the winning team and delete the X's which gave me to results I was looking for but wanted to take it a step further and high lite. What I am aiming to do is high lite the winner (winning row) and if the cell has an X decrement the counter and if not do nothing.

    I have played with the formula some and tried some different scripts but cannot get to work the way I want. I have included the file as I have been playing with it but am not familiar with VBA to make it work, it might even be in my logic in the formula.

    Anyone have any ideas what I need to do? Thanks
    ~Dave
    Attached Files Attached Files
    Last edited by JOB Dave; 12-19-2012 at 07:00 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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