I have an excel sheet with the following layout: My goal is to find each occurrence of a machine number that has a downtime equal to or greater than 4 hours and put that info Plus the reason into a separate table. I want to search by machine number find downtime =>4 and return each occurrence of the machine number, downtime and reason to a separate table to be used as a chart? I have tried MATCH, VLOOKUP, INDEX, MATCH but no joy as yet. Any ideas or help is greatly appreciated.
<colgroup style="box-sizing: border-box;"><col span="2" width="87" style="box-sizing: border-box;"><col width="101" style="box-sizing: border-box;"><col width="156" style="box-sizing: border-box;"></colgroup><tbody style="box-sizing: border-box;">
</tbody>
Machine # | Run Number | Downtime | Reason for down time |
1 | x0 | 0.50 | blah |
2 | xx0 | 3.80 | blah blah |
1 | xxx0 | 7.50 | blah blah blah |
4 | x000 | 2.10 | |
5 | xxxx | 1.40 | |
1 | x0000 | 10.50 | blah boo |
7 | 0000x | 4.00 | boo blah |
Machine # | Downtime > 4 hrs | Reason | |
1 | 7.50 | blah blah blah | |
1 | 10.50 | blah boo | |
7 | 4.00 | boo blah |
<colgroup style="box-sizing: border-box;"><col span="2" width="87" style="box-sizing: border-box;"><col width="101" style="box-sizing: border-box;"><col width="156" style="box-sizing: border-box;"></colgroup><tbody style="box-sizing: border-box;">
</tbody>