Standard Deviation dependent on variable

[Hunter E. Hunt]

Hey guys,

I have got following problem.

I want to calculate the standard deviation of a column, but in dependancy from another column.

Example:

Car Age

Car A 10
Car B 4
Car C 6
Car A 2
Car A 13

How can i calculate the standard deviation of the age of Car A, without seperating the data (I am dealing with a huge dataset). What do I need as an argument in the =STDEV()

Thanks in advance

[quekbc]

Use an array IF function - that is, type

Please Login or Register  to view this content.

then do CTRL SHIFT ENTER instead of just enter.