sorting numbers every 24 rows

[freak11]

hi,
I need a macro that sorts the numbers from smallest to largest every 24 rows.

sorting numbers.xlsx

[mikerickson]

This will break your data into 24 row blocks and sort each block

Please Login or Register  to view this content.

[oeldere]

non VBA solution

d1 =

Please Login or Register  to view this content.

and drag down

I copied the data in column A to column C => paste special => values since you added them with the formula aslect.

After that just sort on column D and after that sort on column C.

See the attached file.

[freak11]

thanks a lot. how can i do it specifically in column h instead of a coz i got another excel file where all the numbers are placed in column h. thanks

This will break your data into 24 row blocks and sort each block

Please Login or Register  to view this content.

[oeldere]

change 1 (= column A) in 8 (column H).

[xladept]

Here's another:

Please Login or Register  to view this content.

[mikerickson]

thanks a lot. how can i do it specifically in column h instead of a coz i got another excel file where all the numbers are placed in column h. thanks

Change this line

Please Login or Register  to view this content.

but that will only sort column H, the other columns will be unchanged.
If you want all the columns to be sorted along with H.

Please Login or Register  to view this content.

[freak11]

can you clarify what you mean? I tried it and it didnt work somehow

non VBA solution

d1 =

Please Login or Register  to view this content.

and drag down

I copied the data in column A to column C => paste special => values since you added them with the formula aslect.

After that just sort on column D and after that sort on column C.

See the attached file.

[oeldere]

You used the formula aselect.

That is the reason differant values been taken.

So i copied the data and paste it as special => values.

Then I used the formula I offered.

Try it and it will work.

[xladept]

My solution and Mike's are nearly identical; did you try either one?