how to create formula.

[Guest]

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\)]

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

 

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

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