I have a report that includes blank cells and zero values. How do I remove all the blanks and zeros from the report using formula? The hour and pieces column both should have values (no Zeros and blanks on both or either columns)
Example:
| Hours | # of Pieces |
| 0.1 | 3 |
| 52 | 191 |
| 0.1 | 3 |
| 42 | 179 |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 0 | |
| 67 | 0 |
------------------------------
Bibhav Rimal
------------------------------