LinkBack URL
About LinkBacks
Hy!
I have a table in Excel like in an attachment.
I would like to calculate a Number average for every day in a year period - beside Number.
How can I do that with macro (loop - for)?
Help please, thanks.
Hy!
I have a table in Excel like in an attachment.
I would like to calculate a Number average for every day in a year period - beside Number.
How can I do that with macro (loop - for)?
Help please, thanks.
I don't follow? What exactly are you trying to average?
Numbers per day. In day 1 we have number 23 at 1 o'clock, 24 at 2 o'clock and so on to 12 at 24 o'clock. So (23+24+...+12)/24=averageOriginally Posted by JapanDave
I don't know how to loop to get average with macro for every day in a year.
Post a sample sheet... I'm tempted to post up pictures of results.
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I can't find GO ADVANCED, so I've just attached xls.
What's red is an average of numbers through day. I want that to be calculated with macro for every day in one year (for example: 1.1.2008-1.1.2009).
hi, johns22, it can be done this way without looping each cell, run code "test"
Last edited by watersev; 10-05-2011 at 07:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks