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.
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 |