Column B Column S
11-12-12 $500
11-12-12 $750
11-13-12 $100
11-17-12 $250
11-28-12 $100
So there are days with multiple values
Column B Dates
Column C values
Column B Column S
11-12-12 $500
11-12-12 $750
11-13-12 $100
11-17-12 $250
11-28-12 $100
So there are days with multiple values
Column B Dates
Column C values
Last edited by jrusso; 11-15-2012 at 07:25 AM.
for the daily average, you can use averageif()
for the weekly and monthly, add 2 extra helper columns,
in the 1st, use =WEEKNUM(B1,1), then use the averageif() function based on that
in the 2nd, use =month(B1), then use the averageif() function based on that
If you still have a problem, upload a sample workbook and I will walk you through it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Book1.zip
here is zipped file
I really do not know what adding helper columns is all about
Does anyone know how to do this?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks