sorting array formulas
Posted by David on August 02, 2001 1:51 PM
I have an array formula applied to several thousand rows, where the result is mostly zeros, with a few non-zeros strew about.
I only want to keep the rows with a non-zero result, but there are too many rows to look through individually and pick out the
ones I want. When I try to sort the whole worksheet by that column, I get an error message that says:
"Can not change part of an array."
So, how can I sort my worksheet?