Hi Guys,

1) I want to find out number repeated max. times in column. Ex. as in first column A '1' is repeated max time.
2) similarly in column D too max. number repeated is 1 but as '1' is already used in
so it should search for next max number repeated in column D
A B C D E
1 4 2 3 5
5 3 4 1 2
1 1 1 1 1
1 4 3 5 2
1 5 4 3 2
2 5 4 1 3


Appreciate your help.

Thanks
VJ