# find out number repeated max. times in column.

1. ## 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

Thanks
VJ

2. ## how to find out number repeated max. times in column

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

Thanks
VJ

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

- Mangesh

4. 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1