Checking for Duplicates accross a workbook

R

RAYCV

Hi, I am using the following array formula to check for duplicates within a
worksheet

{=IF(MAX(COUNTIF('Daniel S'!A4:A1000,A4:A1000))>1,"Duplicate","No
Duplicates")}

Can anybody tell me how to extend this to check the same range across 10
worksheets within a workbook?

Thanks in advance.
 
J

John Spencer

This newsgroup is for Access (a database program). Try posting your question
to one of the Excel newsgroups.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

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

Checking for Duplicates within a Workbook 7
MS Excel Function (Find Duplicate values) 3
Identifying Duplicates in Multiple Sheets 4
Finding Duplicates 4
counting duplicates Among Many Sheets, Possible?? 5
i need to find duplicates! ASAP 4
Checking for duplicates - think this is simple 9
Code for duplicate rows? 5

Top