Sort and bring back data

[namluke]

Hi,

Im trying to sort data from 3 separate columns (smallest to largest), and bring back the data in the colums next to it.

I have put what i would like it to look like in columns A:F (red).

I need colum F to lookup column N column U and column AB and then put it in order from smallest to largest.

Once it has done that i need columns A:E to look up the times in column F and bring back the data related to it.

I have tried a few way but cant seem to crake this one.

Any help would be great!!

[natefarm]

There's no set of formulas that could be used to stack data from multiple sets of variable-height columns on top of each other. You'll need to either copy & paste the data, and then sort it, or if it needs to be repeated fairly often, you'll need VBA code to accomplish it.

[namluke]

no worries, ive found a way to do it. Cheers