Forum Discussion
Advanced Filter/ Removing Duplicates
Is it possible for you to post a file that either is your actual file or is a facsimile with any confidential or private info removed. I'm assuming that your apples and oranges example is itself not the real case. But if you could post a file of your own making that accurately reflects what you're dealing with, it would help target a response.
That said, if you have the most recent release of Excel, it contains some newly released Dynamic Array functions--SORT, UNIQUE and FILTER in particular--that I'm quite sure would work for you. How, exactly, would depend on the actual layout of your data. It will keep up with new additions to the basic table so long as it's arrayed as a real Excel Table.
If you are the type (as I am) that likes to figure these things out for yourself if at all possible, give those functions a try. They make it possible to build-in to a workbook the kinds of operations you've just gone through "manually." If more help is needed, come back with a representative file for us to work with.