|  | Checking for Duplicates accross a workbook | | |
| | | RAYCV |  |
|  Posted: Tue Sep 23, 2008 6:56 am Post subject: Checking for Duplicates accross a workbook |  |
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. |
| |
| | | John Spencer | |
| | Posted: Tue Sep 23, 2008 9:12 am Post subject: Re: Checking for Duplicates accross a workbook | |
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
RAYCV wrote:
| Quote: | 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. |
|
| |
|
|
