software

Hi,

I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
unique site on any given date. What I would like to do, for any given day, is
summarize (avg, max, min, etc) each site's temperature . The way I have done
this before is to have a table with, using this data as an example, 8
columns: Date and 1 column for each site, with temperature the data under
each site's column. I would then just use the avg, max, min, etc functions in
one cell and drag it across to get the summary for each site. This would be
tedious here, however, since I would have to do a bunch of copying and
pasting to get the data arranged in this manner. Any way around this through
nested functions or VB code??

Thanx in advance for any help

Array formulas would help here. Basically the idea is that you multiply
each element of the temperatures array (assumed C1:C10) with a logical
expression evaluating to 0 or 1. However, the operation must be done
for each element of the array, hence they must be entered using
Shift Ctrl Enter

=AVERAGE((C1:C10)*--(A1:A10=quot;My Sitequot;))

You can use this technique for all your aggregate functions with the
exception of MIN. Here, multiplying positive temperatres with 0 would
make 0 the minimum. In this case you can use something like:

=MIN(C1:C10 IF(A1:A10=quot;My Sitequot;, 0, 1000))

HTH
Kostis VezeridesGiz,

Use a pivot table - will do all that and more, automatically.

HTH,
Bernie
MS Excel MVPquot;Gizquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt; unique site on any given date. What I would like to do, for any given day, is
gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt; this before is to have a table with, using this data as an example, 8
gt; columns: Date and 1 column for each site, with temperature the data under
gt; each site's column. I would then just use the avg, max, min, etc functions in
gt; one cell and drag it across to get the summary for each site. This would be
gt; tedious here, however, since I would have to do a bunch of copying and
gt; pasting to get the data arranged in this manner. Any way around this through
gt; nested functions or VB code??
gt;
gt; Thanx in advance for any help
I am trying to get at max, min, avg, the first and third quartiles of data
for temperature for every day. The formula I would use for quartiles is
quot;QUARTILE(selection,1)quot; for the first quartile, for example. How do I get
that in a pivot table?? I have tried to figure it out but am having trouble,
thanks.

quot;Bernie Deitrickquot; wrote:

gt; Giz,
gt;
gt; Use a pivot table - will do all that and more, automatically.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Gizquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt; gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt; gt; unique site on any given date. What I would like to do, for any given day, is
gt; gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt; gt; this before is to have a table with, using this data as an example, 8
gt; gt; columns: Date and 1 column for each site, with temperature the data under
gt; gt; each site's column. I would then just use the avg, max, min, etc functions in
gt; gt; one cell and drag it across to get the summary for each site. This would be
gt; gt; tedious here, however, since I would have to do a bunch of copying and
gt; gt; pasting to get the data arranged in this manner. Any way around this through
gt; gt; nested functions or VB code??
gt; gt;
gt; gt; Thanx in advance for any help
gt;
gt;
gt;

Giz,

I guess it's that etc... part that has jumped up and bitten us. Anyway, let's say that your table
is on Sheet1, with Dates in column A and temperatures in column B - let's say, 1000 rows of data.
Make the pivot table, with dates as the row field, and get your Max, Min, Average, and whatever else
you want that is available using the standard pivot table functionality. Then for the quartiles, in
the next column over from your pivot table, Array enter (enter using Ctrl-Shift-Enter) the following
formula

=QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)

This assumes that the first date of the pivot table is in cell A5 of Sheet2.

Then copy that over for three columns, and change the 1 to 2, then 3, then 4 (for your quartiles),
making sure that you re-enter the formula using Ctrl-Shift-Enter. Then copy down to match the dates
in your pivot table.

HTH,
Bernie
MS Excel MVPquot;Gizquot; gt; wrote in message
...
gt;I am trying to get at max, min, avg, the first and third quartiles of data
gt; for temperature for every day. The formula I would use for quartiles is
gt; quot;QUARTILE(selection,1)quot; for the first quartile, for example. How do I get
gt; that in a pivot table?? I have tried to figure it out but am having trouble,
gt; thanks.
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt; Giz,
gt;gt;
gt;gt; Use a pivot table - will do all that and more, automatically.
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt;
gt;gt; quot;Gizquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt;gt; gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt;gt; gt; unique site on any given date. What I would like to do, for any given day, is
gt;gt; gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt;gt; gt; this before is to have a table with, using this data as an example, 8
gt;gt; gt; columns: Date and 1 column for each site, with temperature the data under
gt;gt; gt; each site's column. I would then just use the avg, max, min, etc functions in
gt;gt; gt; one cell and drag it across to get the summary for each site. This would be
gt;gt; gt; tedious here, however, since I would have to do a bunch of copying and
gt;gt; gt; pasting to get the data arranged in this manner. Any way around this through
gt;gt; gt; nested functions or VB code??
gt;gt; gt;
gt;gt; gt; Thanx in advance for any help
gt;gt;
gt;gt;
gt;gt;
That works, but I don't think it differentiates between the different sites,
in the third column in the original data.

quot;Bernie Deitrickquot; wrote:

gt; Giz,
gt;
gt; I guess it's that etc... part that has jumped up and bitten us. Anyway, let's say that your table
gt; is on Sheet1, with Dates in column A and temperatures in column B - let's say, 1000 rows of data.
gt; Make the pivot table, with dates as the row field, and get your Max, Min, Average, and whatever else
gt; you want that is available using the standard pivot table functionality. Then for the quartiles, in
gt; the next column over from your pivot table, Array enter (enter using Ctrl-Shift-Enter) the following
gt; formula
gt;
gt; =QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)
gt;
gt; This assumes that the first date of the pivot table is in cell A5 of Sheet2.
gt;
gt; Then copy that over for three columns, and change the 1 to 2, then 3, then 4 (for your quartiles),
gt; making sure that you re-enter the formula using Ctrl-Shift-Enter. Then copy down to match the dates
gt; in your pivot table.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Gizquot; gt; wrote in message
gt; ...
gt; gt;I am trying to get at max, min, avg, the first and third quartiles of data
gt; gt; for temperature for every day. The formula I would use for quartiles is
gt; gt; quot;QUARTILE(selection,1)quot; for the first quartile, for example. How do I get
gt; gt; that in a pivot table?? I have tried to figure it out but am having trouble,
gt; gt; thanks.
gt; gt;
gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;
gt; gt;gt; Giz,
gt; gt;gt;
gt; gt;gt; Use a pivot table - will do all that and more, automatically.
gt; gt;gt;
gt; gt;gt; HTH,
gt; gt;gt; Bernie
gt; gt;gt; MS Excel MVP
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Gizquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt; gt;gt; gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt; gt;gt; gt; unique site on any given date. What I would like to do, for any given day, is
gt; gt;gt; gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt; gt;gt; gt; this before is to have a table with, using this data as an example, 8
gt; gt;gt; gt; columns: Date and 1 column for each site, with temperature the data under
gt; gt;gt; gt; each site's column. I would then just use the avg, max, min, etc functions in
gt; gt;gt; gt; one cell and drag it across to get the summary for each site. This would be
gt; gt;gt; gt; tedious here, however, since I would have to do a bunch of copying and
gt; gt;gt; gt; pasting to get the data arranged in this manner. Any way around this through
gt; gt;gt; gt; nested functions or VB code??
gt; gt;gt; gt;
gt; gt;gt; gt; Thanx in advance for any help
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Giz,

To add that condition, simply change

=QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)

to

=QUARTILE(IF((Sheet1!$A$1:$A$1000=Sheet2!$A5)*(She et1!$C$1:$C$1000=Sheet2!$B5),Sheet1!$B$1:$B$1000), 1)

You can add as many conditions as you need by adding additional *(Sheet1!$?$1:$?$1000=Sheet2!$?5) to
the conditional at the beginning of the IF. Just make sure you remember to use Ctrl-Shift-Enter to
enter this...

HTH,
Bernie
MS Excel MVPquot;Gizquot; gt; wrote in message
...
gt; That works, but I don't think it differentiates between the different sites,
gt; in the third column in the original data.
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt; Giz,
gt;gt;
gt;gt; I guess it's that etc... part that has jumped up and bitten us. Anyway, let's say that your
gt;gt; table
gt;gt; is on Sheet1, with Dates in column A and temperatures in column B - let's say, 1000 rows of data.
gt;gt; Make the pivot table, with dates as the row field, and get your Max, Min, Average, and whatever
gt;gt; else
gt;gt; you want that is available using the standard pivot table functionality. Then for the quartiles,
gt;gt; in
gt;gt; the next column over from your pivot table, Array enter (enter using Ctrl-Shift-Enter) the
gt;gt; following
gt;gt; formula
gt;gt;
gt;gt; =QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)
gt;gt;
gt;gt; This assumes that the first date of the pivot table is in cell A5 of Sheet2.
gt;gt;
gt;gt; Then copy that over for three columns, and change the 1 to 2, then 3, then 4 (for your
gt;gt; quartiles),
gt;gt; making sure that you re-enter the formula using Ctrl-Shift-Enter. Then copy down to match the
gt;gt; dates
gt;gt; in your pivot table.
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt;
gt;gt; quot;Gizquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to get at max, min, avg, the first and third quartiles of data
gt;gt; gt; for temperature for every day. The formula I would use for quartiles is
gt;gt; gt; quot;QUARTILE(selection,1)quot; for the first quartile, for example. How do I get
gt;gt; gt; that in a pivot table?? I have tried to figure it out but am having trouble,
gt;gt; gt; thanks.
gt;gt; gt;
gt;gt; gt; quot;Bernie Deitrickquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Giz,
gt;gt; gt;gt;
gt;gt; gt;gt; Use a pivot table - will do all that and more, automatically.
gt;gt; gt;gt;
gt;gt; gt;gt; HTH,
gt;gt; gt;gt; Bernie
gt;gt; gt;gt; MS Excel MVP
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Gizquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt;gt; gt;gt; gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt;gt; gt;gt; gt; unique site on any given date. What I would like to do, for any given day, is
gt;gt; gt;gt; gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt;gt; gt;gt; gt; this before is to have a table with, using this data as an example, 8
gt;gt; gt;gt; gt; columns: Date and 1 column for each site, with temperature the data under
gt;gt; gt;gt; gt; each site's column. I would then just use the avg, max, min, etc functions in
gt;gt; gt;gt; gt; one cell and drag it across to get the summary for each site. This would be
gt;gt; gt;gt; gt; tedious here, however, since I would have to do a bunch of copying and
gt;gt; gt;gt; gt; pasting to get the data arranged in this manner. Any way around this through
gt;gt; gt;gt; gt; nested functions or VB code??
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Thanx in advance for any help
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Is the quot;Sheet2!$B5quot; the title of the quot;sitequot; field in my pivot table? I tried
that but the results don't seem quite correct. The quartiles are lower than
my min value for that site on that date. Thanks for all your help

gt; =QUARTILE(IF((Sheet1!$A$1:$A$1000=Sheet2!$A5)*(She et1!$C$1:$C$1000=Sheet2!$B5),Sheet1!$B$1:$B$1000), 1)

quot;Bernie Deitrickquot; wrote:

gt; Giz,
gt;
gt; To add that condition, simply change
gt;
gt; =QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)
gt;
gt; to
gt;
gt; =QUARTILE(IF((Sheet1!$A$1:$A$1000=Sheet2!$A5)*(She et1!$C$1:$C$1000=Sheet2!$B5),Sheet1!$B$1:$B$1000), 1)
gt;
gt; You can add as many conditions as you need by adding additional *(Sheet1!$?$1:$?$1000=Sheet2!$?5) to
gt; the conditional at the beginning of the IF. Just make sure you remember to use Ctrl-Shift-Enter to
gt; enter this...
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Gizquot; gt; wrote in message
gt; ...
gt; gt; That works, but I don't think it differentiates between the different sites,
gt; gt; in the third column in the original data.
gt; gt;
gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;
gt; gt;gt; Giz,
gt; gt;gt;
gt; gt;gt; I guess it's that etc... part that has jumped up and bitten us. Anyway, let's say that your
gt; gt;gt; table
gt; gt;gt; is on Sheet1, with Dates in column A and temperatures in column B - let's say, 1000 rows of data.
gt; gt;gt; Make the pivot table, with dates as the row field, and get your Max, Min, Average, and whatever
gt; gt;gt; else
gt; gt;gt; you want that is available using the standard pivot table functionality. Then for the quartiles,
gt; gt;gt; in
gt; gt;gt; the next column over from your pivot table, Array enter (enter using Ctrl-Shift-Enter) the
gt; gt;gt; following
gt; gt;gt; formula
gt; gt;gt;
gt; gt;gt; =QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)
gt; gt;gt;
gt; gt;gt; This assumes that the first date of the pivot table is in cell A5 of Sheet2.
gt; gt;gt;
gt; gt;gt; Then copy that over for three columns, and change the 1 to 2, then 3, then 4 (for your
gt; gt;gt; quartiles),
gt; gt;gt; making sure that you re-enter the formula using Ctrl-Shift-Enter. Then copy down to match the
gt; gt;gt; dates
gt; gt;gt; in your pivot table.
gt; gt;gt;
gt; gt;gt; HTH,
gt; gt;gt; Bernie
gt; gt;gt; MS Excel MVP
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Gizquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am trying to get at max, min, avg, the first and third quartiles of data
gt; gt;gt; gt; for temperature for every day. The formula I would use for quartiles is
gt; gt;gt; gt; quot;QUARTILE(selection,1)quot; for the first quartile, for example. How do I get
gt; gt;gt; gt; that in a pivot table?? I have tried to figure it out but am having trouble,
gt; gt;gt; gt; thanks.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Giz,
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Use a pivot table - will do all that and more, automatically.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; HTH,
gt; gt;gt; gt;gt; Bernie
gt; gt;gt; gt;gt; MS Excel MVP
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Gizquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; Hi,
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt; gt;gt; gt;gt; gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt; gt;gt; gt;gt; gt; unique site on any given date. What I would like to do, for any given day, is
gt; gt;gt; gt;gt; gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt; gt;gt; gt;gt; gt; this before is to have a table with, using this data as an example, 8
gt; gt;gt; gt;gt; gt; columns: Date and 1 column for each site, with temperature the data under
gt; gt;gt; gt;gt; gt; each site's column. I would then just use the avg, max, min, etc functions in
gt; gt;gt; gt;gt; gt; one cell and drag it across to get the summary for each site. This would be
gt; gt;gt; gt;gt; gt; tedious here, however, since I would have to do a bunch of copying and
gt; gt;gt; gt;gt; gt; pasting to get the data arranged in this manner. Any way around this through
gt; gt;gt; gt;gt; gt; nested functions or VB code??
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Thanx in advance for any help
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

I got it to work, thank you so very much for the help.

quot;Bernie Deitrickquot; wrote:

gt; Giz,
gt;
gt; To add that condition, simply change
gt;
gt; =QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)
gt;
gt; to
gt;
gt; =QUARTILE(IF((Sheet1!$A$1:$A$1000=Sheet2!$A5)*(She et1!$C$1:$C$1000=Sheet2!$B5),Sheet1!$B$1:$B$1000), 1)
gt;
gt; You can add as many conditions as you need by adding additional *(Sheet1!$?$1:$?$1000=Sheet2!$?5) to
gt; the conditional at the beginning of the IF. Just make sure you remember to use Ctrl-Shift-Enter to
gt; enter this...
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Gizquot; gt; wrote in message
gt; ...
gt; gt; That works, but I don't think it differentiates between the different sites,
gt; gt; in the third column in the original data.
gt; gt;
gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;
gt; gt;gt; Giz,
gt; gt;gt;
gt; gt;gt; I guess it's that etc... part that has jumped up and bitten us. Anyway, let's say that your
gt; gt;gt; table
gt; gt;gt; is on Sheet1, with Dates in column A and temperatures in column B - let's say, 1000 rows of data.
gt; gt;gt; Make the pivot table, with dates as the row field, and get your Max, Min, Average, and whatever
gt; gt;gt; else
gt; gt;gt; you want that is available using the standard pivot table functionality. Then for the quartiles,
gt; gt;gt; in
gt; gt;gt; the next column over from your pivot table, Array enter (enter using Ctrl-Shift-Enter) the
gt; gt;gt; following
gt; gt;gt; formula
gt; gt;gt;
gt; gt;gt; =QUARTILE(IF(Sheet1!$A$1:$A$1000=Sheet2!$A5,Sheet1 !$B$1:$B$1000),1)
gt; gt;gt;
gt; gt;gt; This assumes that the first date of the pivot table is in cell A5 of Sheet2.
gt; gt;gt;
gt; gt;gt; Then copy that over for three columns, and change the 1 to 2, then 3, then 4 (for your
gt; gt;gt; quartiles),
gt; gt;gt; making sure that you re-enter the formula using Ctrl-Shift-Enter. Then copy down to match the
gt; gt;gt; dates
gt; gt;gt; in your pivot table.
gt; gt;gt;
gt; gt;gt; HTH,
gt; gt;gt; Bernie
gt; gt;gt; MS Excel MVP
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Gizquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am trying to get at max, min, avg, the first and third quartiles of data
gt; gt;gt; gt; for temperature for every day. The formula I would use for quartiles is
gt; gt;gt; gt; quot;QUARTILE(selection,1)quot; for the first quartile, for example. How do I get
gt; gt;gt; gt; that in a pivot table?? I have tried to figure it out but am having trouble,
gt; gt;gt; gt; thanks.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bernie Deitrickquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Giz,
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Use a pivot table - will do all that and more, automatically.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; HTH,
gt; gt;gt; gt;gt; Bernie
gt; gt;gt; gt;gt; MS Excel MVP
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Gizquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; Hi,
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I have a table with 3 columns: Site, Temperature, and Date. The quot;Sitequot; field
gt; gt;gt; gt;gt; gt; contains multiple unique quot;Sitesquot; (7 to be precise), and multiple records per
gt; gt;gt; gt;gt; gt; unique site on any given date. What I would like to do, for any given day, is
gt; gt;gt; gt;gt; gt; summarize (avg, max, min, etc) each site's temperature . The way I have done
gt; gt;gt; gt;gt; gt; this before is to have a table with, using this data as an example, 8
gt; gt;gt; gt;gt; gt; columns: Date and 1 column for each site, with temperature the data under
gt; gt;gt; gt;gt; gt; each site's column. I would then just use the avg, max, min, etc functions in
gt; gt;gt; gt;gt; gt; one cell and drag it across to get the summary for each site. This would be
gt; gt;gt; gt;gt; gt; tedious here, however, since I would have to do a bunch of copying and
gt; gt;gt; gt;gt; gt; pasting to get the data arranged in this manner. Any way around this through
gt; gt;gt; gt;gt; gt; nested functions or VB code??
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Thanx in advance for any help
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;