Mon, 9 Jul 2007 04:08:00 -0700 from Quco
:
Hi, I have a LOOOONNNG list of 5-digit numbers in a spreadsheet. They are all
listed in the A column. We only need to report the ranges for this numbers,
not the actual numbers. How can I do that? doing this manually after sorting
the data is taking forever.

What do you mean, "the ranges"?

If you mean the largest and smallest values, see the MAX and Min
functions.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/