Why do you all write those formulas, just use "advanced filter" on the data ribbon. Select your table, select your criterium range and you can select to filter the table itself or put the filtered list somewhere else.