Comparing numbers
 

Hi.

I was thinking to make this in Java but if it's possible/simpler maybe i
can do this in excel...

I have columns A, B, C, D, E filled with 30 rows of different one digit
numbers. My goal is to compare ALL columns and to list out just 4
numbers that are mostly repeated ( they must be repeated at least 3
times ).

So, i must read all digits in column A and compare it to column B and
the all that that with column C etc.

Maybe it would be better to read out each column, store it in cache and
do some bubble sort or something like this..

Comparing numbers
 

One way...

In col F1...

=COUNTA($a:$e,a1)

...and copy down and across to col J!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion