About Us

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!

Spencer101

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
rename column header after filtering column results in the MS SQL	Neall	Excel Programming	1	December 3rd 07 09:05 PM
Filtering a List	HomeBuyingHQ	Excel Discussion (Misc queries)	2	September 24th 07 09:08 AM
How- seperate a combined list by filtering out first list of names	Briana	Excel Worksheet Functions	1	March 21st 06 03:16 PM
Auto filtering vs Date List Create List	torajudo	Excel Worksheet Functions	2	January 29th 06 10:30 AM
trouble filtering a list. Why isn't column filtering?	Pat	Excel Worksheet Functions	1	July 18th 05 03:30 PM

Menu

About Us