G
Guest
Hi,
the problem is need a formula or a macro for my excel 2003 work sheet.
this is part of my work sheet below:
column column
A B
-------------------------------
5 2
6 2
dog 1
dog 2
dog 1
that I want is, how to create a formula or macro to chane ( if column A is
dog, column B at the same row replace to T01 and by order(T02,T03) like
sample below
column column
A B
-------------------------------
9 2
10 2
dog T01
dog T02
dog T03
Regards
Johnny.
the problem is need a formula or a macro for my excel 2003 work sheet.
this is part of my work sheet below:
column column
A B
-------------------------------
5 2
6 2
dog 1
dog 2
dog 1
that I want is, how to create a formula or macro to chane ( if column A is
dog, column B at the same row replace to T01 and by order(T02,T03) like
sample below
column column
A B
-------------------------------
9 2
10 2
dog T01
dog T02
dog T03
Regards
Johnny.