littlevillageIron ContributorJan 02, 2023COUNTIFS duplicate value Hi, How can I write a formula and get the expected result like above image. Hope for your response. Thank you. Show MoreSampleCountifs.xlsx10 KBOliverScheurichJan 02, 2023littlevillage =C2/COUNTIF($A$2:$A$6,A2)You can try COUNTIF instead of COUNTA. SampleCountifs.xlsx9 KB
OliverScheurichJan 02, 2023littlevillage =C2/COUNTIF($A$2:$A$6,A2)You can try COUNTIF instead of COUNTA. SampleCountifs.xlsx9 KB
OliverScheurichJan 02, 2023littlevillage =C2/COUNTIF($A$2:$A$6,A2)You can try COUNTIF instead of COUNTA. SampleCountifs.xlsx9 KB
OliverScheurichGold Contributorlittlevillage =C2/COUNTIF($A$2:$A$6,A2)You can try COUNTIF instead of COUNTA. SampleCountifs.xlsx9 KB
littlevillageIron Contributor to OliverScheurichJan 02, 2023OliverScheurich Thank you very muchit's worked
