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.
[TABLE="width: 431"]
<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;">[TR]
[TD="class: xl63, width: 87"]Machine #[/TD]
[TD="class: xl63, width: 87"]Run Number[/TD]
[TD="class: xl63, width: 101"]Downtime[/TD]
[TD="width: 156"]Reason for down time[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]x0[/TD]
[TD="class: xl64"]0.50[/TD]
[TD]blah[/TD]
[/TR]
[TR]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]xx0[/TD]
[TD="class: xl64"]3.80[/TD]
[TD]blah blah[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]xxx0[/TD]
[TD="class: xl64"]7.50[/TD]
[TD]blah blah blah[/TD]
[/TR]
[TR]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]x000[/TD]
[TD="class: xl64"]2.10[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]xxxx[/TD]
[TD="class: xl64"]1.40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]x0000[/TD]
[TD="class: xl64"]10.50[/TD]
[TD]blah boo[/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl63"]0000x[/TD]
[TD="class: xl64"]4.00[/TD]
[TD]boo blah[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]Machine #[/TD]
[TD="class: xl63"]Downtime > 4 hrs[/TD]
[TD]Reason[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl64"]7.50[/TD]
[TD]blah blah blah[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl64"]10.50[/TD]
[TD]blah boo[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl64"]4.00[/TD]
[TD]boo blah[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 431"]
<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;">[TR]
[TD="class: xl63, width: 87"]Machine #[/TD]
[TD="class: xl63, width: 87"]Run Number[/TD]
[TD="class: xl63, width: 101"]Downtime[/TD]
[TD="width: 156"]Reason for down time[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]x0[/TD]
[TD="class: xl64"]0.50[/TD]
[TD]blah[/TD]
[/TR]
[TR]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]xx0[/TD]
[TD="class: xl64"]3.80[/TD]
[TD]blah blah[/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]xxx0[/TD]
[TD="class: xl64"]7.50[/TD]
[TD]blah blah blah[/TD]
[/TR]
[TR]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]x000[/TD]
[TD="class: xl64"]2.10[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]xxxx[/TD]
[TD="class: xl64"]1.40[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]x0000[/TD]
[TD="class: xl64"]10.50[/TD]
[TD]blah boo[/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl63"]0000x[/TD]
[TD="class: xl64"]4.00[/TD]
[TD]boo blah[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]Machine #[/TD]
[TD="class: xl63"]Downtime > 4 hrs[/TD]
[TD]Reason[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl64"]7.50[/TD]
[TD]blah blah blah[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]1[/TD]
[TD="class: xl64"]10.50[/TD]
[TD]blah boo[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="class: xl63"]7[/TD]
[TD="class: xl64"]4.00[/TD]
[TD]boo blah[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]