Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 to explain my question in detail, Thanks +-------------------------------------------------------------------+ |Filename: find common numbers1.zip | |Download: http://www.officefrustration.com/attachment.php?attachmentid=822| +-------------------------------------------------------------------+ -- alikirca20 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
From 2 rows or column how to find common numbers | Excel Discussion (Misc queries) | |||
Find common text | Excel Worksheet Functions | |||
Need help with Date/ and find most common denominator. | Excel Worksheet Functions | |||
How do I find the 6 most common | Excel Discussion (Misc queries) | |||
HOW TO FIND THE GREATEST COMMON FACTOR | Excel Worksheet Functions |