Hi
any one know how to create a formula to replaced under cell A 11, 12 to any
text and cell B to any number or text I need.
sample below:
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.

I'm afraid your question is not clearly stated. Can you try describing what
you have, and what you want to happen to it, in more detail please?

Rick


"Johnny" wrote in message
...
Hi
any one know how to create a formula to replaced under cell A 11, 12 to
any
text and cell B to any number or text I need.
sample below:
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.

"Rick Rothstein (MVP - VB)" wrote:

I'm afraid your question is not clearly stated. Can you try describing what
you have, and what you want to happen to it, in more detail please?

Rick


"Johnny" wrote in message
...
Hi
any one know how to create a formula to replaced under cell A 11, 12 to
any
text and cell B to any number or text I need.
sample below:
cell
A B
---------------------------------
9 13
9 1
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.

This is what I need after run the formula.
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
USER W01
USER W02
USER W03


"Johnny" wrote:

Hi
any one know how to create a formula to replaced under cell A 11, 12 to any
text and cell B to any number or text I need.
sample below:
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.

Your description is none too clear.

Please re-post with another try at showing what you have and what you want.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 07:28:01 -0800, Johnny
wrote:

Hi
any one know how to create a formula to replaced under cell A 11, 12 to any
text and cell B to any number or text I need.
sample below:
cell
A B
---------------------------------
9 13
9 14
9 15
9 16
10 2
11 1
11 2
12 1

Thanks.