Excel Formula

S

something68

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"?
 
P

Pete_UK

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
 
L

Luke M

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

2) In R8
=D9
In U8
=E9
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top