How to find the most common numbers?

Excel Help for How To Find The Most Common Numbers? in Automating Data Analysis Tasks

Find Excel Solutions


Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?




Follow Business Spreadsheets On:
 
Forum TopicReply Login

How To Find The Most Common Numbers?

Rate this:
(3/5 from 1 vote)
OopsI 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/69466e2c/find_common_numbers.html]

 Posted by on
 
There are currently no replies to the "How to find the most common numbers?" topic of the Excel Help Forum for Automating Data Analysis Tasks.

Reply

Excel templates and solutions matched for How to find the most common numbers?:
Solutions: Business Risk Analysis

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |