check for duplicates in the whole work book

Hi all,

I have a workbook where there are around 10 worksheets. All of them are build the same, but only different sheet name (country name)
What I would like to do is use the column A to check if no one did put a duplicate in a differnt sheet. Now I have a formula in each sheet, but it would be great if it would also look in the rest of the sheets if there is no duplicate.

Can some one put me in the right direction?

Greetings.

Hi,

I'm using this formula now:

=COUNTIF($A:$A,$A305)>1

So maybe there is a way of using the sheets name in it.

Greetings.

Hi,

No one that could help out?

Greetings.

Hi,
Duplicate files are really troublesome. They not only take up your disk space but also make your hard drive an awesome mess. You may need to spend half an hour to find the right file in your hard drive. That is a great waste of time. It is necessary to wipe out duplicates from your computer.
But you can really can find your duplicate files easily by "DuplicateFilesDeleter ".
I hope you can find the best way for find duplicate file by this program.Thanks..