I am needing to check for duplicate entries in various worksheets. I don't
want to remove the duplicates, just see if there are any.

i.e. there is a tab created for each week with patients listed. I am
needing to find out if any patients are on more than one sheet. My unique
identifier is the patient id. I know how to create a formula that will find
duplicates from the previous week but what formula can be used to find
duplicates in multiple sheets?

Thanks for any help.

Tami

http://www.cpearson.com/excel/Duplicates.aspx



--


Regards,


Peo Sjoblom






"Nelson" wrote in message
...
I am needing to check for duplicate entries in various worksheets. I don't
want to remove the duplicates, just see if there are any.

i.e. there is a tab created for each week with patients listed. I am
needing to find out if any patients are on more than one sheet. My unique
identifier is the patient id. I know how to create a formula that will
find duplicates from the previous week but what formula can be used to
find duplicates in multiple sheets?

Thanks for any help.

Tami