Sorting an array of numbers into one column

Sorry guys, I think my task is rather simple but I can't think of a better way to do it other than manual operations.

Basically I have an array of numbers randomly populating a range, lets say B1 to Z44, and it includes blanks. I want to have all the numbers piled into one column, eg. A1:A__, without the blanks. What would be the best way to do it, if possible without a macro? I imagine this should be rather simple...? Order of number is not important so long as every non-blank cell is included.

Thank you very much in advance, any help is much appreciated.

Hi,

a possible approach in A1 to be copied down

Ascending order

=IFERROR(SMALL(B$1:Z$44,ROW(A1)),"")



Descending order

=IFERROR(LARGE(B$1:Z$44,ROW(A1)),"")


Cheers

Check if this is useful for you.

A1:

Formula:

Please Login or Register  to view this content.

and copy down until you start getting blanks


Regards, TMS

If it's something you do regularly, this small VBA routine could save you some time:

Please Login or Register  to view this content.

Regards, TMS