R
Rocketeer
I'm trying to create statistics from a sheet with order data from my webshop.
Each row consists of an order with:
Column A = order number
Column B = Payment option
Column C = Order date
Example:
1 PayPal 010110
2 VISA 010110
3 PayPal 020110
4 PayPal 020110
5 PayPal 020110
6 AMEX 030110
I'm interested to count how many orders have been placed each day during a
month and display an average based on the dates in column C. That is, 1st of
January = 2, 2nd of January = 3 etc. So for the three days above the average
number of orders/day = (2+3+1)/3 = 2.
I'm also interested to see the maximum number of orders for one day during a
month. That is, for the three day example above the result will be 3.
Best
Each row consists of an order with:
Column A = order number
Column B = Payment option
Column C = Order date
Example:
1 PayPal 010110
2 VISA 010110
3 PayPal 020110
4 PayPal 020110
5 PayPal 020110
6 AMEX 030110
I'm interested to count how many orders have been placed each day during a
month and display an average based on the dates in column C. That is, 1st of
January = 2, 2nd of January = 3 etc. So for the three days above the average
number of orders/day = (2+3+1)/3 = 2.
I'm also interested to see the maximum number of orders for one day during a
month. That is, for the three day example above the result will be 3.
Best