maybe this will work for you .... This formula works based on the following
Old Names start in D3
New Names start in F3
copy this formula into C3 and copy down
Code:=IF(D3="","",COUNTIF($F$3:$F$210,D3))
you can adjust $f$210 if you need to i just picked a random stopping point .
Bookmarks