Sorting Items by Length for a target length list.

[Joe Bob Crain]

Find the value for three joints of pipe to fit within a specific value, (ex.85 to 92 foot range.) from a list while keeping the the joint numbers with the three length joint lengths to match the range between X feet and X feet.

JT. # LENGTH
301 39.54
302 38.40
303 42.38
304 37.72
305 38.50
306 40.83
307 42.37
308 40.38
309 31.60
310 41.90
311 38.42
312 46.25
313 38.62
314 42.25
315 39.75
Thank you in advance for your help.
Joe Bob Crain

[oldchippy]

Hi Joe Bob Crain,

Have a look at this link, similar question, it may help you?

http://www.excelforum.com/showthread...hlight=lengths

oldchippy