Loop up formula across multiple sheets

[kevexcel]

[COLOR=rgba(0, 0, 0, 0.9)]Hi All,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]I am wondering if anyone can help I am looking to create a formula in Excel which looks accross 3 sheets to identify within these sheets if there are duplicate values accross each sheet.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]So Ideally it would lolok accross sheets and then in a new overview tab it would return the URLs from those sheets which are duplicate in column a, b, c for example or in one column[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]
[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]Does anyone know anything that could help?[/COLOR]
[COLOR=rgba(0, 0, 0, 0.9)]
[/COLOR]

 

[kevexcel]

Hi All,






I am wondering if anyone can help I am looking to create a formula in Excel which looks accross 3 sheets to identify within these sheets if there are duplicate values accross each sheet.






So Ideally it would lolok accross sheets and then in a new overview tab it would return the URLs from those sheets which are duplicate in column a, b, c for example or in one column






Does anyone know anything that could help?

 

[Aladin Akyurek]

Care to post a small sample from two of the sheets?