Sunday, December 16, 2018

BEGINNER

CHARTS

WORKSHEETS

FILES

FORMATTING

FORMULAS

FUNCTIONS

GENERAL

MACROS

OUTLOOK

PRINTING

PROTECTION

See More Categories

Categories

RECENT

Free To Do List Template

What is the best way to find duplicates in a workbook with over 40 worksheets? This workbook has over 5,000 names separated into different groups (worksheets). We use this list as a basis for invitation lists. We usually have over 100 names duplicated and are trying to find the best way to highlight the duplicates - we have tried many different methods in the past, but none that finds all the dupes.

MOST VIEWED