Am wondering if there is the ability with Excel to find duplicates in a list of data. For example, if I have a list of customer #’s and their related sales activity. Short of sorting the list and looking through it manually, is there a way to haveExcel tell me which customer numbers are duplicates (or triplicates, etc.) – that I can see at a glance which customers have more than one activity? It is a large list (thousands of lines). Would appreciate any insight anyone has in this regard. Thanks!
