Help in finding duplicate values in a column

[suresh kumar s]

Hi,

Please refer the below table. Column A data and Column B result (i want )

In the below table column "data" contains some data with duplicate values . I want a formula to show only maximum duplicate values in result column.

Data	Result
3	1
3
3
3
1
1
1
1
1

Thanks in advance,
Suresh

 

[Fluff13]

How about
=MODE(A2:A10)

 

[suresh kumar s]

How about
=MODE(A2:A10)

Thank you

 

[Fluff13]

You're welcome & thanks for the feedback.