How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1967
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
Type Your Programming Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

In column I enter numbers and I want to divide by 20 in

Customer Question

in column B I enter numbers and I want to divide by 20 in column C and divide by 18 in column D I want to keep a running avg for both column for 150 days
Submitted: 2 years ago.
Category: Programming
Expert:  Ratheesh Ravi replied 2 years ago.
Hi ,
Please check the excel sheet with the required formulas here -
Please let me know if you need anything more.
Customer: replied 2 years ago.
that's not what I wanted // After I have 20 numbers in column B then I want a running avg incolumn C and after 20 numbers in B I want a 18 day avg of the last 18day in column D // then on 21 day I want a avg of numbers from B2 to B21 in column C and 18 day in D //every day a NEW avg of the last 20 days in column C //and 18 days in column D
Expert:  Ratheesh Ravi replied 2 years ago.
I will opt out of the question so that other expert can join to help you.
Sorry for the inconvenience.
Expert:  The-PC-Guy replied 2 years ago.
is there any way you can send an example of what you are looking to do?