LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
en2 en2 is offline
external usenet poster
 
Posts: 1
Default 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..

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing 3 numbers [email protected] Excel Discussion (Misc queries) 10 May 18th 09 10:10 PM
Comparing two columns of numbers PaladinWhite Excel Worksheet Functions 2 June 1st 08 11:46 PM
Comparing numbers/figures Lona M. Excel Worksheet Functions 1 December 19th 07 02:24 PM
Need help comparing 6 of 10 numbers [email protected] Excel Programming 3 March 7th 07 01:21 PM
comparing 2 columns of numbers Gary Keramidas Excel Programming 2 October 20th 06 07:17 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"