+ Reply to Thread
Results 1 to 5 of 5

create an algorithmor vba in which one can determine how many times a number appears in to

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    create an algorithmor vba in which one can determine how many times a number appears in to

    it is possible to create an algorithm in which one can
    Determine how many times a number appears
    In total bets? Example we will make 40 bets on a 60/6 lottery
    In the number 05 appears 30 times and the number 26 appears 8 times (it is just an example)
    Objective is to take the nuven or graph of higher percentage of certain number in detriment of others
    Example = in the algorithm I type in a field the number of times the number should appear in the bet amounts
    Example 05 = 30 times 26 = 8 times .....

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: create an algorithmor vba in which one can determine how many times a number appears i

    reading your question, I would solve this with a pivot table.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Re: create an algorithmor vba in which one can determine how many times a number appears i

    Okay, I need you to create the PivotTable
    And the fields to put the quandary of each numbers present in an amount of games

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: create an algorithmor vba in which one can determine how many times a number appears i

    Please read #2 again.

  5. #5
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Re: create an algorithmor vba in which one can determine how many times a number appears i

    Okay, but you have to create the macro or vba !!
    And then post, you have to create the algorithm
    To do the requested task.

+ 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. Trying to find number of times an ID number appears in a data list
    By RohanF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2015, 09:12 PM
  2. Calculating number of times individual number appears in a pivot table
    By snoopy1461 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-15-2014, 08:39 AM
  3. [SOLVED] Count the number of times an A appears 5 or more times consecutively
    By CCook310 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-02-2013, 04:02 PM
  4. Replies: 1
    Last Post: 07-18-2013, 10:11 AM
  5. count the number of times a number appears in a specific range
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:01 AM
  6. Replies: 3
    Last Post: 09-17-2012, 08:05 AM
  7. Replies: 5
    Last Post: 11-22-2010, 06:31 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