Thread: Excel Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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"?