# Finding duplicates

#### FROGGER24

##### Well-known Member
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.

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### BobUmlas

##### Well-known Member
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

##### Well-known Member
Bob, your formula worked great thank you for your time and help!

Replies
7
Views
170
Replies
3
Views
106
Replies
2
Views
192
Replies
1
Views
75
Replies
15
Views
203

1,195,956
Messages
6,012,538
Members
441,706
Latest member
lizfourcorners

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back