ExcelBanter - View Single Post

Alan Beban[_2_]

Alan Beban wrote:

wrote:

Unfortunately, its highly likely that my arrays will be longer than
there are rows in Excel. I think I'm going to have to find an
alternative method here to accomplish what I was trying to accomplish -
probably an entirely different approach.

Attached is some code that "converts" a 6000-element vertical array into
three 2000-element arrays and extracts lower and upper bounds for
particular occurrences of the specified values. It's quick and dirty,
but perhaps it could be adapted to convert a 2.4M-element array into
forty 60,000-element arrays to accomplish your purposes. . . .

The code suggests essentially all the operative portions that would
support an adaptation as described. It does, however, assume that the
number of *unique* elements in the, e.g., 2.4M-element code is less than
the number of rows possible on an Excel worksheet. If that were also
not the case, significant additional code would need to be incorporated
in an adaptation.

Alan Beban