I am trying to apply 2 filters to the same column, but I am unable to.
I tried doing something like this:
and none of them worked.
Any help will be greatly appreciated.
What I would like to do is filter column a by using both criteria.
Thanks in advance.
I tried doing something like this:
VBA Code:
=FILTER(A:A,AND(A:A="Honduras",A:A="Nicaragua"))
=FILTER(A:A,AND(A:A="Honduras")*(A:A="Nicaragua"))
Any help will be greatly appreciated.
What I would like to do is filter column a by using both criteria.
Thanks in advance.