Help filtering date related data
 

I have created a simple spreadsheet that contains the following data for
2006

Column A - WEEKDAY function reading from Column B (values 1-7)
Column B - date
Column C - # of Orders
Column D - Total Revenue
Column E - Avg Revenue per order

Each row in the spreadsheet is a date of 2006, starting with Jan 1. My
challenge is to create a formula that pulls all of the info for a given
day of the week and creates benchmarks for trend analysis. For
example, I want calculate the average number of orders received on a
Monday from Jan 1 - present. Data for future dates are prefilled with
0. Sample is as follows:



A B D D
E
1 01/01/2006 82 14201.70
173.19
2 01/02/2006 155 23339.30
150.58
3 01/03/2006 171 27979.57
163.62
1 01/08/2006 154 34360.55
223.12

Help filtering date related data
 

Hi,

use auto filter and:

Filter column A =2 then

Filter column B Jan-01-2006

use a formula on column d to see the average of # Orders
=subtotal(1,d2,d100) adjust for your range

hth
regards from Brazil
Marcelo

"mgalloway" escreveu:


I have created a simple spreadsheet that contains the following data for
2006

Column A - WEEKDAY function reading from Column B (values 1-7)
Column B - date
Column C - # of Orders
Column D - Total Revenue
Column E - Avg Revenue per order

Each row in the spreadsheet is a date of 2006, starting with Jan 1. My
challenge is to create a formula that pulls all of the info for a given
day of the week and creates benchmarks for trend analysis. For
example, I want calculate the average number of orders received on a
Monday from Jan 1 - present. Data for future dates are prefilled with
0. Sample is as follows:



A B D D
E
1 01/01/2006 82 14201.70
173.19
2 01/02/2006 155 23339.30
150.58
3 01/03/2006 171 27979.57
163.62
1 01/08/2006 154 34360.55
223.12
.