Home Tags Search
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.
The solution to this problem can be approached in a number of ways. In this post we will describe and method that uses VLOOKUP a built-in Excel function to derive the result.
For this example we have a list of transactions by date for a series of account numbers. We want to calculate the total transactions for each account number into a summary report. As there are a number of transactions for each Account Number we need to use a combination of Find and FindNext to continue searching through the whole range.
In our previous post on Find and FindNext we saw that in combination they can be used to search through large amounts of data very quickly. In many cases we need to use Find and FindNext on a worksheet. The best way to implement repeatable and automated worksheet based functions is through User Defined Function (UDF). This is just a function written in VBA code that can be used on a worksheet.