Searching whole base for duplicates

[Katie_James1]

How can I search for duplicates across a whole base, not just within one table?

Thanks!

[Radhe-iad]

I would suggest using an external too like Make or Zapier that you can instruct to search for both values and if there is a match you can update a variable or something that keeps track of it.