assigning id's
 

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

assigning id's
 

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

assigning id's
 

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