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.