IF Statement Help Please :)

[jeffj13]

Hello, appreciate any help provided!

I want to create a statement that returns a yes or no response if certain criteria are met in another column. However, I want to only apply this argument within the same cell values of the corresponding ID. For the example below, for ID 123 I want to check if both "DI" and "OL" exist in the service code column. But I only want to check this for 123 and for the formula to switch the test for 456. I would like it to return no if " DI" and "OL" are present and yes if only "DI" is present. Not sure how to apply this to only the same ID in the first column without crossing over into the next ID. I should also add that the ID's are completely random and I never know exactly what numbers will be used.

ID	Service Code
123	RE
123	DI
123	OL
456	RE
456	DI

 

[jeffj13]

Weird. Not sure it works regarding the opening post and post number 3.

I misspoke slightly in post 3 regarding the logic on the alpha characters. The COUNTIFS for column A within my IF statement was what I was missing and it helped me figure it out from there.

 

[steve the fish]

No worries always good to figure stuff out yourself.