find out number repeated max. times in column.

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

Can some one least guide me ... as i am not conforatble with excel programming

Thanks
Vijay

Originally Posted by vimivijay

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

To get the number repeated the max times, use
=MODE(A1:A10)
assuming the range is A1:A10

- Mangesh

A crude method for the second part, enter the following formula in the cell:
=MODE(IF(D1:D10=1,"a",D1:D10))
and press Control + Shift + Enter

Note: in the above formula, all the 1s in the column D are replaced with "a" and then the mode is found. Mode ignores text. If you want to link it to another cell say A15 which holds the mode for column A, then replace 1 in the above formula with A15.

- Mangesh