Hi,

Im dealing with a large dataset which is poorly formatted. A few days ago i asked this question http://www.excelforum.com/showthread...50#post4456950 ;
about how to generate a mean of every nth cell.

A user helped me out with the formula ;

=AVERAGEIF(A$1:A$79,"?*",A2:A80) which works perfectly. But the STDEV function doesnt have the same range lookup function so its not directly interchangeable.

I was curious how i would generate a standard deviation for such mean. Ive tried manipulating the formula reported in here http://www.mrexcel.com/forum/excel-q...-each-row.html but i cant get it to work.

Cheers,

G