Hi,

Am Wed, 11 Nov 2015 16:32:58 +0000 schrieb CP514:

i would like to assign a number value from 1-30 for each name, always
resetting to 1 at a new name. this database is pertperually growing, so
names are not always in the same row day after day.

your names in column A.
Try in B1:
=A1&" "&COUNTIF($A$1:A1,A1)
and copy down.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional