Filtering Based in a cell value

  • Thread starter Thread starter Steve Wright
  • Start date Start date
S

Steve Wright

I have a list which I want to filter based on the value of a cell that is
not in that list.

Any ideas?

eg

List of values to be filtered in Column X

aaa
aaa
bbb
bbb
ccc
ddd
eee
fff
ggg


The value I want to filter by in A1 derived from Data validation list on
separate sheet

aaa


I want to filter out all the values that are not aaa


TIA
Steve
 
How about a helper column with a formula like:

=a2=sheet2!$a$1
(dragged down)

Then you can filter on True/False for that column.
 
Maybe a VBA macro using this line would work for you:

Range("X1").AutoFilter Field:=1, Criteria1:="<>" & Range
("A1")
 
Back
Top