Thank you for your quick reply. The data was to the right, but I moved it up so that when filtering it wouldn't remove any of the results. It can be on a seperate worksheet, but would prefer it to be on the same sheet.

XL2007 is correct.

The data is in a table, so does that change anything on your first step you gave me?