I have a large table in Excel that I need to filter on 3 times. I'd like to use a series of combo boxes or cell validation on 3 cells to distill the data. First cell only displays the unique items in column1 of the table. Second cell then the items from col21 that qualified after the first pass. Third cell then does the same for criteria set by first two reductions. Very much an autofilter type application but I don't want the user in the table at all. I've written some knarly code to do this by brute force into a series of three combo boxes. I am wondering now if there is a more elegant way to approach this problem perhaps allowing direct entry into cells using validation (or other) without having to write the brute force matrix searches.