[SOLVED] Mass sort of rows from left to right

[Marcosm31414]

I have a set of data that needs to be sorted from a select set of rows from left to right and from the smallest to the largest number.
Tried the custom sorting function but it only does one row at the time.

Thanks everyone.

[kcarley]

Would you be able to attach an example workbook. You may want to simplify the amount of data and provide a 'hand' solved sheet too. I understand you're looking for the automated way but I can't visualize what you're describing as the sort function should work swimmingly.

[M E Good @ XL4M]

Assume your data is in columns A to say column Z. Select all data and move to column AA
A2 =IF(ISERROR(SMALL($AA2:$BA2,COLUMNS($A:A))),"",SMALL($AA2:$BA2,COLUMNS($A:A))) then copy across to Z2 and down to match column AA

Adjust cell references to suit your requirements . Leave headers in original position if used.

[kcarley]

#Marcosm31414

If M E has solved this for you then please change the thread title to start with [SOLVED] and don't forget the little star in the lower left of his post to add to his reputation.

I would tweak the formula just a bit in A2

Please Login or Register  to view this content.

Works the same but less to type.

If you don't want to have to move your data around...
Based on this logic (visualized with thanks to #M E Good @ XL4M or "M E" for short) I would use VBA that I can call on when needed. Let me know if you need help trying this out but basically you would add this to a module and use it when needed.

Please Login or Register  to view this content.

Cheers!
K

[Marcosm31414]

Thanks everyone for your help. All of the answers worked.
One issue that I was overlooking is that my columns heading do not change.

Marcos

[Marcosm31414]

Thanks for your help. It worked

[kcarley]

Glad to help!

You or anyone that happens to find any post or posts helpful in a thread are encouraged to add to the reputation of those that created the post. Just click the star in the bottom left of the post! You don't even have to comment but that's always nice too.

Enjoy!
K