Hi All
i have weekly data in a sheet , after every 5 rows i want to calculate a average for the above 5 rows. The number of rows might increase,so i started with a rows.count code
any further info you want please let me know
Please Login or Register to view this content.
Never confuse a single defeat to the final defeat.
no VBA needed.
f6=if(and(C5>0,C6=""),average(C1:C5),"")
and drag across.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Just so you know how, this works using VBA as long as you keep 2 rows inbetween each set of data.
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
Thank you guys for your help.
Glad the options worked for you. Thanks for the rep as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks