Ordering numbers!

[Motilulla]

Hello Folks, here's another question for you;

In the file that i have attached, i have a group of 49 numbers which are separated into three segments. What i want to do is to order these numbers into ascending order from the cells B2 to AX2. For example in Segment 1 which is from B6:G9 number 1 should go in B2 number 5 should go in F2 number 7 should go in H2 and like that consecutively...

Thank you

[Richard Buttrey]

Hello Folks, here's another question for you;

In the file that i have attached, i have a group of 49 numbers which are separated into three segments. What i want to do is to order these numbers into ascending order from the cells B2 to AX2. For example in Segment 1 which is from B6:G9 number 1 should go in B2 number 5 should go in F2 number 7 should go in H2 and like that consecutively...

Thank you

Hi,

If I've understood this requirement, put the following in B2 and copy across.

Please Login or Register  to view this content.

Adapt it for rows 3 & 4 changing the segments as appropriate.

HTH

[Motilulla]

Awesome! amazing reply, thank you very much Mr.Richard!

Now i have another question, i want to create a macro to arrange the numbers of each segment in ascending order in the columns J K L. For Example the numbers of segment 1 should be arranged from 1 to 49 starting from J3 in ascending order!...

Thanx..

(file is attached)

[mikerickson]

Mortilulla,

If you read the link in my signature, you'll see why the rules require that you post a link to your cross-post.
http://www.mrexcel.com/forum/showthread.php?t=309737

It can be annoying to work on a problem that has been solved in the other thread.