Comparing numbers

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top