Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding new records in subsequent reports (XL07)
I'm helping a colleague who receives a monthly report which grows by about 25K rows per month. There is one field from which we generate a list of unique values using AdvancedFilter; the resulting list is about 10K rows. On a month to month basis, we need to compare the previous unique list to the current unique list, and create a third list that contains ONLY the new values that show up in the current list that were not present in the previous list. I can do this by looping through either list and doing a Application.Match against the other list, and writing those values to a new sheet, but I was wondering if there is a cleaner way to do this. I was amazed when I learned how to use AdvancedFilter to create the original unique list, so I figured I'd check here to see if there was any similar built-in functionality (or a criteria I could use with AdvancedFilter) to generate only those values that aren't in both lists. Thanks for enlightening me! Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Unique records | Excel Discussion (Misc queries) | |||
Finding subsequent matches | Excel Worksheet Functions | |||
Finding Duplicate records | Excel Programming | |||
finding records | Excel Programming | |||
Code not finding records | Excel Programming |