Data Sort
Do you mean that you have two columns of data? If so, are these columns
A and B? Which column do you want to sort on? Does this column contain
a mixture of numbers and text?
One way to do this is to use a helper column (column C), whereby if
there is a number in column A (assuming you want to sort on this
column) you can change this to "zzzz"&number.The following formula in
C2:
=IF(ISNUMBER(A2),"zzzz"&TEXT(A2,"000000"),A2)
can be copied down for as many items as you have in column A, and is
suitable for numbers up to 1,000,000. Then you can sort on column C and
delete column C after the sort.
Hope this helps.
Pete
The Toasterman wrote:
I have two rows of data that need to be sorted. The data includes text &
number strings & I need to text to remain at the top after the sort.
Is this possible?
|