Finding duplicates

[FROGGER24]

in A2 I need a formula that will look at the value in E2 and if it is "Crude" then use formula C2=C1,0,1 and if E2 does not contain "Crude" then use formula B2=B1,0,1.. thanks for any help given.

 

[BobUmlas]

in A2 I need a formula that will look at the value in E2 and if it is "Crude" then use formula C2=C1,0,1 and if E2 does not contain "Crude" then use formula B2=B1,0,1.. thanks for any help given.

=IF(E2="Crude",IF(C2=C1,0,1),IF(B2B1,0,1))

 

[FROGGER24]

Bob, your formula worked great thank you for your time and help!