I have a table that I am trying to use the filter function to report the names based on last names and the priority level. Currently I am able to use the filter function to look at a specific name in a drop down but it does not do it based on priority. The list currently has 59 values and I am trying to cut down the time it takes and create an easier way to look based on the priority levels. I do have other criteria it is looking (date ranges attached to the names). I am not able to manipulate the data on Table1 due to legalities.