Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing 3 numbers | Excel Discussion (Misc queries) | |||
Comparing two columns of numbers | Excel Worksheet Functions | |||
Comparing numbers/figures | Excel Worksheet Functions | |||
Need help comparing 6 of 10 numbers | Excel Programming | |||
comparing 2 columns of numbers | Excel Programming |