A Alina_T Member Mar 31, 2022 #1 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! Attachments draft_advanced filter.xlsx draft_advanced filter.xlsx 188.9 KB · Views: 5
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!
A Alina_T Member Apr 1, 2022 #3 Thanks a lot! Seems I didn't understand well advanced filter, I will read more about it. Thanks again!
Thanks a lot! Seems I didn't understand well advanced filter, I will read more about it. Thanks again!
Hui Excel Ninja Staff member Apr 1, 2022 #4 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
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
