Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
assigning id's
hey all,
i have a column type ==== 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ==== 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ==== 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of Id's in one Colum list of names in another. More Id's on s | Excel Discussion (Misc queries) | |||
Unique ID's | New Users to Excel | |||
User ID's | Excel Worksheet Functions | |||
column id's | Setting up and Configuration of Excel | |||
Face ID's | Excel Discussion (Misc queries) |