Posted by Kevin Smith on January 07, 2002 7:11 AM
I enter several rows of data. My need is to compute an average of the last seven entries in a column. However I want to ignore any zeroes. Example if mu last 10 entries were 1,2,3,4,5,0,0,6,7,8. I would want the average of 2,3,4,5,6,7,8. Any help would be appreciated.