formula to pick specific text from same date

[koi]

hi all,

need some advice here on how to make a formula to pick a specific date from same date,

i have 3 columns A (Date), B (Name) and C (status : success or fail),
A2:A10 = date, B2:B10 = Name and C2:C10 = status

all i want is example
A2 : 1 jan 2014, A3:1 jan 2014
B2 : a, B3 : a
C2 : fail, C3 : success

then insert a formula/helper column say like "ok" or "not" so when i pivot the data and put the helper column, we can see that on 1 Jan 2014, there is only 1 name with status fail.

attached is the file

thanks guys for any help/advice

 

[chirayu]

If I understood correctly - you need to structure your data like this and apply pivot on it

Date | Name | Status | Helper
1-Jan-14 | John | Fail | Formula

The formula in the helper column would be:

=IF(C2,"Fail","not","ok")