I am wondering if there is an easy way to find the MIN, MAX, MEDIAN,
AVERAGE, MODE for housing prices in different areas. I am able to export
data to EXCEL format and currently, I laboriously have to DL excel sheets
for 1 "AREA" at a time and paste a 5 cell template of formulas on row 1
to caculate those values successfully.

Instead of setting up the software and downloading 1 area at a time, I am
able to select multiple areas and then export them to an excel sheet. one
of the columns in the sheet contains the AREA NUMBER.

It would be exponentially easier to export MULTIPLE AREAS, and somehow
perform these calculations (which I don't know how to set up) which would
lookup a column, say column d, and then calculate MIN, MAX, MEDIAN, AVERAGE,
MODE for each set of areas.

small sample data: (TAB SEPARATED)

AREA LIST PRICE
101 100,000
101 125,000
101 212,000
101 225,000
101 232,500
235 199,900
235 212,500
235 229,000
235 249,000
322 89,500
322 99,999
322 102,850


I wonder if there is a way to examine column A, detect how many different
values there are (EXAMPLE 3) and then detect how many rows correspond to
each value (EXAMPLE: 101=5, 235=4, 322=3) and then use that information to
perform the MIN, MAX, MEDIAN, AVERAGE, MODE to the corresponding column
which in the example would be column B.

I apollogize as I am a novice with more complicated formulas, I am hoping
the solution will pop right out for some of you here in this forum.

Thanks!
-cypher