Excel Formula
 

Two part question:

D8 shows "H" and D9 shows "8"
E8 shows "MO" and E9 shows "8"
How can I have column V8 show "8", "8"?

AND

D8 shows "s" and D9 shows "8"
E8 shows "SF" and E9 shows "8"
How can I have column R8 show "8" and Column U8 show "8"?

Excel Formula
 

Is there any particular relevance as to what D8 and E8 contains?

Do you want R8 and U8 to show whatever is in D9 and E9, irrespective
of D8 and E8, or only if they contain the values "s" and "SF"
respectively?

I'm a bit confused.

Pete

On Jul 24, 3:22*pm, something68
wrote:
Two part question:

D8 shows "H" and D9 shows "8"
E8 shows "MO" and E9 shows "8"
How can I have column V8 show "8", "8"?

AND

D8 shows "s" and D9 shows "8"
E8 shows "SF" and E9 shows "8"
How can I have column R8 show "8" and Column U8 show "8"?

Excel Formula
 

What is the point/value of D8 & E8? (why mention them?)
1) In V8, input:
=D9&", "&E9

2) In R8
=D9
In U8
=E9
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"something68" wrote:

Two part question:

D8 shows "H" and D9 shows "8"
E8 shows "MO" and E9 shows "8"
How can I have column V8 show "8", "8"?

AND

D8 shows "s" and D9 shows "8"
E8 shows "SF" and E9 shows "8"
How can I have column R8 show "8" and Column U8 show "8"?