You could use this formula in B1 copied down
=IF(AND(COUNTIF(A$1:A1,A1)>1,COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1)),A1&" "&COUNTIF(A:A,A1)," ")
You could use this formula in B1 copied down
=IF(AND(COUNTIF(A$1:A1,A1)>1,COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1)),A1&" "&COUNTIF(A:A,A1)," ")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks