advanced filter

[Alina_T]

Hello! Please help me with advanced filter..I want to filter all items without zero in all columns. I don't know what I'm doing wrong.
Thank you!

 

[p45cal]

Your criterion range should be like this:

 

[Alina_T]

Thanks a lot! Seems I didn't understand well advanced filter, I will read more about it. Thanks again!

 

[Hui]

Consider each item in a row as an "And" ie: All criteria in a Row must be true to match
Consider each row as an "Or" ie: Each row allows you to say Crietria in Row 2 or Criteria in Row 3 etc

 

[Alina_T]

thank you!