Sort

  • Thread starter Thread starter JM
  • Start date Start date
J

JM

Is there an Excel function for sorting a list? I'd like
to use it in an array formula.

Thanks,
JM
 
Frank,

Thanks again.

Since you've been so kind to continue to answer
questions, I was hoping that you could give me help with
a problem that I posted earlier today with subject "SUM
causes strange error". Basically, what is happening is I
have constructed a complex array formula that returns an
array of values. I've checked that it works exactly as I
intended by evaluating it in a column of my sheet.
However, whenever I try to apply functions like SUM or
AVERAGE to the array, Excel complains about COUNTA(A:A)
in the middle of the formula that worked perfectly well
by itself.

The only thing that I can think of is that it has
something to do with the fact that I am converting an
array result into a single cell. I'm at a loss. I've
tried to implement my array formula problem in 3-4
different ways and every time, I'm running into this
problem (which is somewhat unavoidable since the desired
result is a single value --- it's also maddeningly
frustrating because the conversion from array to single
cell is the last step). Do you have any ideas on what
might be going on here?

Thanks again for the pointer on sorting.

Jim
 
I see the other reply that I got from you and Mr.
McGimpsey that the nesting limitation is being exceeded.

Thanks for your help.

Jim
 
Back
Top