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

**jorel** · 08-27-2017, 08:50 AM

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 .....

**oeldere** · 08-27-2017, 11:34 AM

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.

**jorel** · 08-27-2017, 04:20 PM

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

**oeldere** · 08-28-2017, 02:16 AM

Please read #2 again.

**jorel** · 08-28-2017, 07:35 PM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Trying to find number of times an ID number appears in a data list

Calculating number of times individual number appears in a pivot table

[SOLVED] Count the number of times an A appears 5 or more times consecutively

IF formula to calculate number of times a number appears in a range based on the next cell

count the number of times a number appears in a specific range

[SOLVED] Counting the number of times an employee number appears in multiple sheets.

Count A Number Of Times A String Appears but display the number sequence

Bookmarks

Bookmarks

Posting Permissions