PDA

View Full Version : Avg last ten



Dipwad
05-24-2010, 11:58 AM
I have a row 30 columns wide. not every cell contains data. I would like to be able to take the last ten cells that contain data & average those. This is probably pretty simple for some of you guys but I am unable to figure it out. Any help is appreciated.