On Sat, 21 Jun 2008 20:54:01 -0700, Brian Mc in StL <Brian Mc in
wrote:

I need to determine mean, median, mode, min, max and rank for a set of data
that exceeds a count of 255. Excel keeps locking up on me I think because
these functions are limited to arrays of 255 numbers or less.

Is there a way I can calculate these statistics on sets of data numbering in
the thousands?

More data would be useful to try to figure out your problem, and why your Excel
is "locking up" (whatever that means)

=MIN(A:A)
=AVERAGE(A:A)
=MODE(A:A)

works fine with values in column A.

etc.
--ron