assigning id's

[rodchar]

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

 

[Gary''s Student]

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

 

[rodchar]

thanks for the help,
rod.

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