Am I understanding correctly that you want filter A2:A100 in sheet X to a sheet Y by applying the conditions/criteria that a filtered value must not be MALE or CLUB or 0?On 2002-08-24 14:30, Mauricio Samy Silva wrote:
Assuming range A20:A100 to be filtered;
Range A1:A4 has restrictions for filtering;
A1 and A20 are label cells of course
I want hidde cells whit 0 (zero), MALE and CLUB, and displays all others.
What must I type in A2=> (>0)???, A3=>(>MALE)???, A4 (>CLUB)???. I do it but don't work, it hidde only zeros (hi). Help, how do!