Filtering a column from a list
 

I have a worksheet that contains 11218 rows. I have a list of 560 values that will appear in Column F that I want to filter out of the 11218 rows. Help!

Assuming that your list of 11218 values is in column A (A2 downward) and your list of 560 values is in column Z (Z1 to Z560), in B2 enter =COUNTIF(Z$1:Z$560,A2) and copy down to row 11219. Apply the auto filter to row 1 and filter column B.

Zeroes mean the value in A does not appear in Z. Any other number will denote how many times the value appears in Z.

Hope that makes sense.