Quote:
Originally Posted by Jenniferpod
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.