nc_waggoner
New Member
- Joined
- Sep 2, 2016
- Messages
- 21
Hi, my goal is to create a reference sheet that only displays rows with valid data. In the below example (Sheet 1), I would like to display the same information on another sheet (Sheet 2) but omit the entire row for samples 4 and 7 due to one of the tests being blank. Does anyone know how to accomplish this?
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Date | Sample | Test 1 | Test 2 | Difference |
8/24/2016 | 1 | 35.1 | 35.7 | -0.6 |
8/25/2016 | 2 | 34.8 | 35.3 | -0.5 |
8/26/2016 | 3 | 36.1 | 37.5 | -1.4 |
8/27/2016 | 4 | 35.7 | 35.7 | |
8/28/2016 | 5 | 35.4 | 36.4 | -1 |
8/29/2016 | 6 | 34.9 | 36.2 | -1.3 |
8/30/2016 | 7 | 37.1 | -37.1 | |
8/31/2016 | 8 | 33.2 | 34.8 | -1.6 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>