STDEVIF Equivalent

I know there have been previous posts of this but I personally haven't been able to find a solution to help me solve my problem. I have data which is reported by frame number but for many trajectories. I currently use the averageif function to group the data based off frame number and then calculate the average distance traveled by all particles in that frame. I would like to do the same thing now but with the standard deviation. The Frame number is reported in column A, and I would like to group all of the data by frame number and then calculate the standard deviation for each frame. I've attached a sample workbook to view the formatting of the worksheet.

Try this user defined function.

Please Login or Register  to view this content.

See the attachment for an example.

How about just an array formula? In M4 and copy down,

=STDEV(IF($A$1:$A$270=K4, $G$1:$G$270))

The formula MUST be confirmed with Ctrl+Shift+Enter.

Originally Posted by shg

How about just an array formula? In M4 and copy down,

=STDEV(IF($A$1:$A$270=K4, $G$1:$G$270))

The formula MUST be confirmed with Ctrl+Shift+Enter.

Shg,

I was thinking about using an array formula but I wasn't positive if it would work. I think between both answers provided I should be able to calculate what I need.However, in my macro I am having trouble correcting the syntax to have the formula apply any data set independent of the size of the data. I attempted the following but had no luck:

Please Login or Register  to view this content.

Thanks again