How do I find (not delete) duplicates in multiple spreadsheets?

N

Nelson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with formula to weed out duplicates 4
Augmenting an integer in a column to reflect duplicates in another 23
comparing columns in two spreadsheets 1
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
Duplicates Formula 3
Checking for Duplicates within a Workbook 7
find duplicates and concatenate 1
How to delete duplicates and also count them 3

Top