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

Finding Duplicate Rows & Highlighting them 6
Duplicate Values in Excel 2007 6
Macro to delte Duplicate rows across multiple sheets 0
VLOOKUP duplicate values in table the table array? Help me solve 1
Condition Formats for duplicates with additional criteria 5
How to assign unique number to column duplicates? 3
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Data Validation, Identify Duplicates and Limit imput 11

Top