Help to Identify an exception

[david gabra]

Hi

I have an excel outpout showing who transfered data.
There is an owner to the task to transfer and there are also sub task.
I need to identify cases where the MASTERTASK (column B) is repeating itself (can be many times) & the owner column (I) have different names.
In column J to add word exception.

Example attached.

thanks

David.

 

[GraH - Guido]

if you have FILTER ( ) available, you may try:

=IF(COUNTA(FILTER($I$2:$I$11,($B$2:$B$11<>"")*($B$2:$B$11=B2),0))>1,"Exception","")