Hello
I'm trying to find average rolling data(5 days) from average daily data , The problem is some of average daily data is missing value and
when I want to rolling them if it found missing value I want to choose average daily data before found missing value. How can I do it with formula
Thank you
In C2:
Please Login or Register to view this content.
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Quang PT
wow.. That's work!
I’m really appreciate for your help.
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks