R
Rita Palazzi
Windows 2000
Office 2000
Hi Folks,
Hopefully someone can help me with a problem. I have a huge spreadsheet that
gathers data every day. There is a date column so each row represents values for
one day. There is also a month column that indicates which month that date falls
into i.e. every day in June will have a 6 for the month.
I have another spreadsheet that summarizes the daily worksheet into months,
usually giving the average daily value for the each month. However, I have one
column that I need to know the maximum value (highest volume) on.
How do I write a function that will look at the column only for one month and tell
me the maximum value for that month?
Thanks in advance for any help you can give.
Rita Palazzi
Engineer / FedEx Express
Office 2000
Hi Folks,
Hopefully someone can help me with a problem. I have a huge spreadsheet that
gathers data every day. There is a date column so each row represents values for
one day. There is also a month column that indicates which month that date falls
into i.e. every day in June will have a 6 for the month.
I have another spreadsheet that summarizes the daily worksheet into months,
usually giving the average daily value for the each month. However, I have one
column that I need to know the maximum value (highest volume) on.
How do I write a function that will look at the column only for one month and tell
me the maximum value for that month?
Thanks in advance for any help you can give.
Rita Palazzi
Engineer / FedEx Express