How to find the most common numbers?

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

How To Find The Most Common Numbers?

Rate this: (3/5 from 1 vote)

	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/69466e2c/find_common_numbers.html]
	Posted by alikirca20 on 10 Apr 2009

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