Hi,

I am trying to find the number of which alplhanumeric value
is repeated maximum times in a column in an excel sheet.
I have an excel 2007 sheet containing a column with many
alphanumeric values which are repeated sometimes in the same column.
I need to find out which value is repeated the maximum number of
times and how many times that particular value is repeated.
The excel sheet is attached for refrence here.

In the example i have 30 rows and the column with the heading Issue number
contains some aplhanumeic values like VALUE100001072, VALUE100001225
etc. I need to find out which value (Issue number) is repeated maximum times in
the column and how many times. In the example here the output should be:
VALUE100001072 repeated 6 times.
I need to use funtions or formulas for the same.
Thanks in advance.