 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2007Sales 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 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  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > Hi > [quoted text clipped - 27 lines] > 01.11.07 Item 2 28.000 56.179 > 01.12.07 Item 2 10.000 20.006 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.