Hello experts,

i have a huge database of entries from a survey generated from google forms into excel. long story short i have various pivot tables and iferror(vlookup) functions. but i am doing something manually and i wonder if you can help me.

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.

this is what i need a formula for:

john smith 1
john smith 2
john smith 3
mike ward 1
mike ward 2
jane doe 1
jane doe 2
jane doe 3
jane doe 4
jane doe 5
Bill Pull 1

etc

thanks for your help

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

Hi

Assuming the data is in A1:A11.

In B1 and copy down: =COUNTIF(A$1:A1,A1)

Worked perfectly thank you!