i need to extract the first and last row of data for each engine ID and put them into seperate work books one for first, one for last test If there is only one test on the engine , it must go in both workbooks. here is a sample of my data, i have 2400 points to go through and dont want to sort it by hand.....not great at excel looking to just get my data and make charts.
its laid out in just 2 columns:
engine ID REAR IMBALANCE
[TABLE="width: 219"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2261055
[/TD]
[TD]84
[/TD]
[/TR]
[TR]
[TD]2261055
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]1051635[/TD]
[TD="align: right"]32
[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]332
[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]49[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]64
[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]79[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 219"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2261055
[/TD]
[TD]84[/TD]
[/TR]
[TR]
[TD]2261055[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]1051635[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]332[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]49[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]79[/TD]
[/TR]
</tbody>[/TABLE]
its laid out in just 2 columns:
engine ID REAR IMBALANCE
[TABLE="width: 219"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2261055
[/TD]
[TD]84
[/TD]
[/TR]
[TR]
[TD]2261055
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]1051635[/TD]
[TD="align: right"]32
[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]332
[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]49[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]64
[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]79[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 219"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2261055
[/TD]
[TD]84[/TD]
[/TR]
[TR]
[TD]2261055[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]1051635[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]332[/TD]
[/TR]
[TR]
[TD]2731075[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]49[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]2731125[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]2261021[/TD]
[TD="align: right"]79[/TD]
[/TR]
</tbody>[/TABLE]