Hi,

I forgot to note that the formula below is Array Entered so press
Shift+Ctrl+Enter to enter it.

Cheers,
Shane Devenshire

"Shane Devenshire" wrote in message
...
Hi,

You really need to give us more info. For example 1. which columns
control the sort order, 2. What type of data is in those columns - number
or text or dates, 3. is the data in the sort controlling column(s) unique
or can there be repeats?

You could try something like this

=INDEX(M,MATCH(ROW(C1),COUNTIF(M,"<="&M),0))

In this case I have named a single column that you want sorted M, suppose
that was A1:A100 on another sheet. You can fancy up this formula to
handle each of the columns in the data area by assigning M for the sort
column and N for the entire range, then the formula would read

=,INDEX(N,MATCH(ROW(C1),COUNTIF(M,"<="&M),0))

and you would change the last 0 to 1, 2, 3, ... to indicate the column of
the range N that you are returning.

This formula does not handle duplicates in the sort range.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Mike" wrote in message
...
I have created a worksheet that is generated by formulas which bring in
the
data from other sheets. I am unable to sort the data and I beleive it is
because of the formulas.
I copied the data to another worksheet with out the formulas and I am
able
to sort but I can't be doing that.

what can I do?