S Shabbo Member Jan 30, 2025 #1 Dear Sir, I have data like same name repeated in same column and I wanted to give them name as per attached excel. Attachments countif.xlsx countif.xlsx 8.7 KB · Views: 3
Dear Sir, I have data like same name repeated in same column and I wanted to give them name as per attached excel.
AliGW Well-Known Member Jan 30, 2025 #2 You have a column of text items and a column of numbers - is it the numbers you want to generate? If so, this in B1 copied down: =COUNTIF(A$1:A1,A1)
You have a column of text items and a column of numbers - is it the numbers you want to generate? If so, this in B1 copied down: =COUNTIF(A$1:A1,A1)
