Hi Guys
I have really complex situation would appreciate your help. In column “A” some values are repeated several times. And column “B” values could be different for each repeated value. Is there any way I can put a formula in column “C” based on below 3 conditions for example if cell A10,A11&A12 have duplicate values:
Condition1: B10,B11&B12 has values between 1 to 3. C10,C11&C12 should all show “YES”.
Condition2: B10,B11&B12 has values between 4 to 11. C10,C11&C12 should all show “NO”.
Condition3: B10,B11&B12 has values between both sets(1 to 3 & 4 to 11). C10,C11&C12 should all show “NO”.
Example file is attached
Bookmarks