CountIf - calculate how many times the name has been listed

**c_m** · 04-19-2009, 06:02 PM

Try in B1:
=IF(AND(COUNTIF(A:A,A1)>1,COUNTIF(A1:$A$1,A1)=COUNTIF(A:A,A1)),A1&" "&COUNTIF(A:A,A1),"")
and copy down

and for conditional formatting, select the used range of column B and try this formula:
=B1<>""

to highlight the names in the list (column A), try this formula in conditional format:
=COUNTIF(A:A,A1)>1

**sable** · 04-19-2009, 06:07 PM

That's great! Thanks a lot for the quick response too. Any suggestions on how to colour those cells? If not, then the formula you gave me will work fine on its own.

I didn't think there was a way to do that. Thanks again!