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.
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.