COUNTIFS duplicate value

[small_village]

Hi, 

How can I write a formula and get the expected result like above image.

Hope for your response.

Thank you.

[#2 · Accepted solution]

@small_village 

=C2/COUNTIF($A$2:$A$6,A2)

You can try COUNTIF instead of COUNTA.

 

[#3]

@Quadruple_Pawn 

Thank you very much

it's worked