how to sort a range which is calculated by array formula
 

when I try to sort the range, the excel says "cannot change part of a
array",I try to find the infomatino about these,but with no luck.
thanks in advance for any help

how to sort a range which is calculated by array formula
 

Copy/Paste as values, first. If that's not an option (i.e. you need
the array formula to update), then perhaps you need to rewrite the
formula.

On Dec 11, 7:58 pm, leoease wrote:
when I try to sort the range, the excel says "cannot change part of a
array",I try to find the infomatino about these,but with no luck.
thanks in advance for any help