2 Columns with dates in them - formula to show what column has a date?

[Daniellel]

Hi,

Thank you in advance if you can help with this...

I have 3 columns (Name, Pass Date, Fail Date) Each name will only have 1 date in either column B or C.

I want a formula that will say "if there is a date in the pass column (B) then this name is a pass, if there is a date in the Fail column (C) then this name is a Fail"

Can anyone help me with this?

Danielle

 

[Akashwani]

Hi Danielle.

Do you mean something like this?...

Excel Workbook
	A	B	C	D	E	F	G	H
1	Name	Pass Date	Fail Date	Result		Name	Result
2	Bill	15/04/2013		This name is a Pass		Bob	This name is a Fail
3	Ben		15/04/2013	This name is a Fail
4	Bud	15/04/2013		This name is a Pass
5	Bob		15/04/2013	This name is a Fail
6	Su	15/04/2013		This name is a Pass
7	Sue		15/04/2013	This name is a Fail
8	Sid		15/04/2013	This name is a Fail
9
Sheet4

The formula in D2 needs to be copied down.
You can also have the name entered into a cell and the result populated along side it as in the example in F1:G2.

I hope that helps.

Ak

 

[Daniellel]

Thats great! thank you so much!

 

[Akashwani]

Hi,

I'm pleased it worked for you and thanks for the feedback.

Ak