Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sales Budget 2007 per Weekday
Hi
Is there someone that can help me with my budget for the year 2007. I have about 200 items in my budget and the breakdown is per month. What I need to do is to breakdown every item per Weekday. Sample of my budget: Month Item Quantity Value 01.01.07 Item 1 30.000 60.192 01.02.07 Item 1 30.000 60.192 01.03.07 Item 1 30.000 60.192 01.04.07 Item 1 20.000 40.128 01.05.07 Item 1 20.000 40.128 01.06.07 Item 1 20.000 40.128 01.07.07 Item 1 20.000 40.128 01.08.07 Item 1 22.000 44.141 01.09.07 Item 1 22.000 44.141 01.10.07 Item 1 22.000 44.141 01.11.07 Item 1 28.000 56.179 01.12.07 Item 1 10.000 20.006 01.01.07 Item 2 30.000 60.192 01.02.07 Item 2 30.000 60.192 01.03.07 Item 2 30.000 60.192 01.04.07 Item 2 20.000 40.128 01.05.07 Item 2 20.000 40.128 01.06.07 Item 2 20.000 40.128 01.07.07 Item 2 20.000 40.128 01.08.07 Item 2 22.000 44.141 01.09.07 Item 2 22.000 44.141 01.10.07 Item 2 22.000 44.141 01.11.07 Item 2 28.000 56.179 01.12.07 Item 2 10.000 20.006 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sales Budget 2007 per Weekday
Hi
You can filter on weekdays with EasyFilter and copy to a new sheet http://www.rondebruin.nl/easyfilter.htm Or you can insert a helper column with a weekday function and filter on that column -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Benedikt Fridbjornsson" wrote in message ... Hi Is there someone that can help me with my budget for the year 2007. I have about 200 items in my budget and the breakdown is per month. What I need to do is to breakdown every item per Weekday. Sample of my budget: Month Item Quantity Value 01.01.07 Item 1 30.000 60.192 01.02.07 Item 1 30.000 60.192 01.03.07 Item 1 30.000 60.192 01.04.07 Item 1 20.000 40.128 01.05.07 Item 1 20.000 40.128 01.06.07 Item 1 20.000 40.128 01.07.07 Item 1 20.000 40.128 01.08.07 Item 1 22.000 44.141 01.09.07 Item 1 22.000 44.141 01.10.07 Item 1 22.000 44.141 01.11.07 Item 1 28.000 56.179 01.12.07 Item 1 10.000 20.006 01.01.07 Item 2 30.000 60.192 01.02.07 Item 2 30.000 60.192 01.03.07 Item 2 30.000 60.192 01.04.07 Item 2 20.000 40.128 01.05.07 Item 2 20.000 40.128 01.06.07 Item 2 20.000 40.128 01.07.07 Item 2 20.000 40.128 01.08.07 Item 2 22.000 44.141 01.09.07 Item 2 22.000 44.141 01.10.07 Item 2 22.000 44.141 01.11.07 Item 2 28.000 56.179 01.12.07 Item 2 10.000 20.006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weekday function in excel 2007 wrong | Excel Discussion (Misc queries) | |||
I want to track sales, gp vs. budget I need a template | Excel Discussion (Misc queries) | |||
Divide Monthly Sales Budget to Day budget | Excel Programming | |||
Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions | |||
Sales budget | Excel Worksheet Functions |