Checking for Duplicates accross a workbook

  • Thread starter Thread starter RAYCV
  • Start date Start date
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.
 
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
 
Back
Top