T tanwar New Member Nov 27, 2022 #1 I need help on Countif if name repeat Attachments Countif.xlsx 9.2 KB · Views: 3
B bosco_yip Excel Ninja Nov 27, 2022 #2 Try, In D2, formula copied down: =IF(A2="","",A2&COUNTIFS(A$2:A2,A2))
T tanwar New Member Nov 27, 2022 #3 bosco_yip said: Try, In D2, formula copied down: =IF(A2="","",A2&COUNTIFS(A$2:A2,A2)) View attachment 81845 Click to expand... Thank u sir it works perfectly
bosco_yip said: Try, In D2, formula copied down: =IF(A2="","",A2&COUNTIFS(A$2:A2,A2)) View attachment 81845 Click to expand... Thank u sir it works perfectly
B bosco_yip Excel Ninja Nov 27, 2022 #4 tanwar said: Thank u sir it works perfectly Click to expand... You are welcome Regards