Formula to return blank where email adress duplicated and Branch name the same

[Howardc1001]

I have branch names in Col H and a formula in Col I to extract the email adresss


Where the sheet name is the same and email address is duplicated, the only display the email addresses not duplicated i.e, only display the first email address not duplicated

I have should what the result in Col I should look like in Col J


It would be appreciated if someone could amend my formula in Col I

[wk9128]

Cell I2 formula , Drag down

Please Login or Register  to view this content.

[Howardc1001]

Many Thanks for the help

[wk9128]

@Howardc1001 You're Welcome. Glad to help . Thank You for the feedback and rep.