thanks for the help,
rod.

"Gary''s Student" wrote:

In B1 enter 1
in B2 enter:

=IF(A2=A1,B1,B1+1)

for example:

house 1
house 1
house 1
cat 2
cat 2
flower 3
flower 3
flower 3
rat 4
hat 5
bat 6
bat 6
bat 6
bat 6

the number remains the same until the item in column A changes
--
Gary''s Student - gsnu200825


"rodchar" wrote:

hey all,

i have a column

type
====
email
email
phone
phone

is there a way to assign duplicate id's in the column next to the type?

for example,

type,id
email,1
email,1
phone,2
phone,2

thanks,
rodchar