Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

COUNTIFS duplicate value

Iron Contributor

Hi, 

small_village_1-1672679079951.png

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

Hope for your response.

Thank you.

 

2 Replies
best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage 

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

You can try COUNTIF instead of COUNTA.

countif.JPG 

@OliverScheurich 

Thank you very much

it's worked

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage 

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

You can try COUNTIF instead of COUNTA.

countif.JPG 

View solution in original post