P Pinang Member Jan 25, 2023 #1 Hi, I am trying to achieve below result with count if formula but its not working for me. could you please help. below is result. NameCount resultA1B2C3D4A1B2E5
Hi, I am trying to achieve below result with count if formula but its not working for me. could you please help. below is result. NameCount resultA1B2C3D4A1B2E5
B bosco_yip Excel Ninja Jan 25, 2023 #2 Try, In B2, formula copied down: =IF(ISNUMBER(MATCH(A2,A$1:A1,0)),IFERROR(VLOOKUP(A2,A$1:B1,2,0),1),SUMPRODUCT(1/COUNTIF(A$2:A2,A$2:A2))) or, =IF(ISNA(MATCH(A2,A$1:A1,0)),SUMPRODUCT(1/COUNTIF(A$2:A2,A$2:A2)),IFERROR(VLOOKUP(A2,A$1:B1,2,0),1))
Try, In B2, formula copied down: =IF(ISNUMBER(MATCH(A2,A$1:A1,0)),IFERROR(VLOOKUP(A2,A$1:B1,2,0),1),SUMPRODUCT(1/COUNTIF(A$2:A2,A$2:A2))) or, =IF(ISNA(MATCH(A2,A$1:A1,0)),SUMPRODUCT(1/COUNTIF(A$2:A2,A$2:A2)),IFERROR(VLOOKUP(A2,A$1:B1,2,0),1))
