Compare text values in multiple columns, identify duplicates and ignore cells

[ahmerafzal]

Can someone please help me and provide a formula to compare text values in multiple columns, if same value exists then Column H is duplicate also ignore empty cells

Thanks in advance

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smozgur]

Thank you very much its work perfectly

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.