Automatically fill a cell based only on a non-zero value in another cell

[l1011driver]

Thanks in advance for any help or advice.

I'm not sure how to include an Excel fragment in the post so I'll do it the old fashioned way.

I have 4 columns. In column A are calendar dates. In column B are values of either 0, 1 or 2. These values are manually inserted by the user.

What I would like to do is this:

If column B is a non-zero value I would like Excel to insert the date of the corresponding cell in column A into column C. In column D I would like Excel to insert the non-zero value from column B. If the value in column B is 0 then I would like Excel to ignore both the 0 and the corresponding date.

For example:

A B C D

June 1 1 June 1 1
June 5 0 June 10 2
June 10 2
June 30 0

Is there a formula or a macro that will allow me to do this?

Thanks for any help or ideas.

 

[My Aswer Is This]

If A1 has "1/8/2017" how does that correspond to a "2" in "B1"

you said:
There will never be a value entered in a cell in column B that doesn't have a date associated with it in column A

 

[l1011driver]

Hi My Answer Is This,

Have you any further thoughts on this?

Thanks...

Mark