Comparing numbers

  • Thread starter Thread starter en2
  • Start date Start date
E

en2

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..
 
Back
Top