Results 1 to 5 of 5

Macro for counting result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Macro for counting result

    Hello there,

    I would be extremly thankfull if anybody could help me solv this.
    I have a macro that generates random numbers in row 1 A - H and then compaire the result with fixed numbers. The result after it has been compaired wil show behind each row in column I.
    This is all working, but I need the results to be counted for each time I push the commandbutton.

    Example:

    everytime a result in column I show:

    4 rette or 4+1 rette should be registered as 1 in N1
    5 rette or 5+1 rette should be registered as 1 in N2
    6 rette or 6+1 rette should be registered as 1 in N3
    6+1 rette should be registered as 1 in N4
    7 rette should be registered as 1 in N5

    The counting in N1 - N5 is not to be deleted when running it again


    Thanks in advace

    Best regards
    Øystein
    Attached Files Attached Files
    Last edited by Oeysbrei; 12-16-2020 at 05:58 AM. Reason: To explane more spesific what to solve

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transaction Register Help
    By stevenp1977 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-06-2019, 01:52 PM
  2. Attendance Register
    By hardice2005 in forum Office 365
    Replies: 1
    Last Post: 01-19-2018, 06:18 PM
  3. Help! Need Check Register
    By bookbuyer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2016, 05:43 PM
  4. Replies: 7
    Last Post: 11-27-2015, 11:12 AM
  5. Register balance
    By simplyimperfect86 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2015, 06:28 PM
  6. Sum in a register
    By Trisarahtops in forum Excel General
    Replies: 4
    Last Post: 10-04-2014, 11:50 AM
  7. Register DIY add-in
    By Huyeote in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2007, 11:25 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