Find duplicate values

[excel_learner]

Thanks, but it gives yes even where 9 and 5 are not linked. e.g if you apply the formula and check seq no (JE) 2357 it has only 9 no repeat on 5. I want to mark yes for all the records where seq no (JE) is repeating with division 5 and 9 and if it is for 5 and 9 alone then NO.