Changing the sort order

[liampog]

Hi there

Currently I have a macro set up that sorts a range.

It sorts numbers first in ascending order and then text comes at the bottom of the sorted range.

Is there any way of reversing this so that text appears first and then numeric values in ascending order below?

THanks,
Liam

 

[Tom Urtis]

Just thinking out loud, have you considered using a helper column, example, if your data of numbers and text is in column A, then in the next available column of your table you could enter and copy down:
=ISTEXT(A1)

Then, Copy and paste special for values that helper column, and sort the table with the primary field being that column, for descending order (because TRUE for text would sort above FALSE). Then for the secondary column A, sort in ascending order and that might all get you what you want. Finish up by deleting the helper column.