Hello,

looking for a way to get the STD dev of the previous 20 values in a column that contains some intermittent blank cells in the column..

only want the STD dev of those previous 20 cells in a column that actually contain values.

is there a way to do this in excel

thanks!