COUNTIFS duplicate value

[littlevillage]

Hi, 

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

Hope for your response.

Thank you.

[#2 · Accepted solution]

@littlevillage 

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

You can try COUNTIF instead of COUNTA.

 

[#3]

@OliverScheurich 

Thank you very much

it's worked