Custom Data Extraction Help

staylor32

New member
Joined
Feb 11, 2013
Messages
1
Reaction score
0
Points
0
i need to extract the first and last row of data for each engine ID (there are multiple instances 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.

Partial Engine IDImbalance
( x 10[SUP]-2 [/SUP]in-oz)
105163532
2051740144
205174029
2250844390
225084475
225084430
2261016209
226101636
2261021113
226102181
226102179
226102165
226102135
226105584
226105550
2305028184
2305028119
230502861
230502818
233066011
233066016
233066041
233066045
233066060
233066077
233066052
233066047
233066038
236085820
2360858333
2360858122
236085832
236085820
236085825
2360858255
236085863
236085841
236085878
2360858126
23608586
236085820
236085888
236085844
236085872
23608588
23608584
236085882
236085882
 
Top