
March 2nd, 2004, 06:04 PM
|
 |
Addicted to Chaos..
|
|
Join Date: Jan 2003
Location: Ft. Worth, TX
Posts: 653
Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0
|
|
Why dont you do this.. it'll take a lot of cycles, but it will work
in vba in excel, make a macro that will go through the list, starting at the top, sort them, then do a count for how many of a certain number there are..
example
you have a list of 12,12,88,12,3,4,5,6,7,12
start macro
do a while x <> "" (assign x to the value of the current cell) and then go down the list until it counts up all of the entries..
next
do while y <= x and search for the first entry, and so on and so forth.. its possible, just get your thoughts in line..
Quote: | Originally Posted by Usalabs I have a problem, I've tried doing this in visual basic, qbasic, and machine language, but I can't seem to be able to find a away to enter a matrix of 2 digit numbers, (12 groups of 20 numbers), then display the most repeated numbers from the matrix, so I thought I could try it with excel 2000, but I don't know much about excel, only cell formating and basic math.
If some one could help with this, it would be much appreciated. |
|