| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking for Duplicates within 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")} Is there a way that I can extend this so that it checks the same range across 10 worksheets within a workbook. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
| Make list of cells in array and checking for duplicates | Excel Worksheet Functions | |||
| checking for duplicates | Excel Worksheet Functions | |||
| Error Checking for Duplicates in List | Excel Worksheet Functions | |||
| Checking for duplicates - think this is simple | Excel Discussion (Misc queries) | |||
Threaded Mode
