Bearcats_85

Posts: n/a

Rolling Average

i am trying to average the smallest 7 numbers out of the last ten entered (i
can to work if all ten cells have data), how do i handle blank cells so i
still look at ten cells of data. The data is entered per day and if a day is
missed i want to ignore and average with the last ten days data was entered

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
plotted Average	Micayla Bergen	Charts and Charting in Excel	4	July 15th 05 12:13 PM
What is this kind of average called?	havocdragon	Excel Worksheet Functions	3	June 24th 05 05:10 PM
AVERAGE and STDEV functions with logic	t-rung	Excel Worksheet Functions	1	May 26th 05 07:11 PM
Average the Last Five Cells in a Column	Warrior Princess	Excel Worksheet Functions	3	March 16th 05 02:12 PM
Z Chart i.e. top rolling annual bottom rolling monthly middle cum.	wat prin	Excel Worksheet Functions	0	January 28th 05 03:43 PM

All times are GMT +1. The time now is 02:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us