Hummmm.... never worked with arrays before, will try this after while...
Thanks for the help.
Bill
"Max" wrote in message ...
Since you have
.. 4 columns of numbers 0 - 9, about 1500 rows deep
Think we could just hardcode the "0 - 9" bit in the formula
Put in H2 and array-enter the formula by pressing CTRL+SHIFT+ENTER:
=INDEX({0;1;2;3;4;5;6;7;8;9},MATCH(MAX(COUNTIF(A2: A1500,{0;1;2;3;4;5;6;7;8;9})),COUNTIF(A2:A1500,{0; 1;2;3;4;5;6;7;8;9}),0))
Copy H2 across to K2 to return the desired results for A to D
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---