Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find the most common numbers?
I have 300 number groups and each group has 22 different numbers (from 1 to
80). I want to find 5 (or more) numbers that occur together the most. Can I find these numbers by excel, macro, VBA or any program? (for example, let us suppose that 4-15-23-36-45 are the most common numbers and these numbers are in 8 groups from 300.) Is it possible , I added my file download link and explain my question in detail, Thanks. http://www.2shared.com/file/5296705/...n_numbers.html |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find the most common numbers?
Hi,
Can I suggest in future you use the site below to upload files, the one you used creates popups so i didn't look at your file http://www.savefile.com/ Mike "alikirca20" wrote: I have 300 number groups and each group has 22 different numbers (from 1 to 80). I want to find 5 (or more) numbers that occur together the most. Can I find these numbers by excel, macro, VBA or any program? (for example, let us suppose that 4-15-23-36-45 are the most common numbers and these numbers are in 8 groups from 300.) Is it possible , I added my file download link and explain my question in detail, Thanks. http://www.2shared.com/file/5296705/...n_numbers.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find the most common numbers? | New Users to Excel | |||
From 2 rows or column how to find common numbers | Excel Discussion (Misc queries) | |||
Random Numbers with certain numbers more common than others | Excel Worksheet Functions | |||
Find rows with a common item and find or highlight difference | Excel Programming | |||
How to find the most common pair and triplet numbers? | Excel Programming |