Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is the question about excel. I need to filter only 0 value within multiple columns and rows Below is the example. As you can
This is the question about excel. I need to filter only 0 value within multiple columns and rows
Below is the example. As you can see those highlighted are the one I have to show to use filter option. I know I can use filter and change one by one of columns to set 0 value. However, I have date with more than 30-40 columns and 100+ rows. Is there way to filter when entire row is 0? And show only single row is 0?
Products | Quantity 1 | Quantity 2 | Quantity 3 |
Product 1 | 4 | 6 | 5 |
Product 2 | 3 | 6 | 6 |
Product 3 | 6 | 87 | 8 |
Product 4 | 0 | 0 | 0 |
Product 5 | 3 | 0 | 0 |
Product 6 | 0 | 5 | 0 |
Product 7 | 3 | 0 | 0 |
Product 8 | 9 | 0 | 0 |
Product 9 | 0 | 6 | 8 |
Product 10 | 0 | 6 | 0 |
Product 11 | 0 | 4 | 6 |
Product 12 | 2 | 0 | 5 |
Product 13 | 1 | 0 | 0 |
Product 14 | 0 | 0 | 0 |
Product 15 | 0 | 0 | 0 |
Product 16 | 0 | 0 | 0 |
Product 17 | 0 | 6 | 5 |
Product 18 | 0 | 4 | 0 |
Product 19 | 0 | 0 | 0 |
Product 20 | 0 | 0 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started