STD formula that searchers for 'like' values

[Dojorgen]

Hey guys always such great help!!!!

Problem statement: need a formula that searches for like 'A' in column A and creates STD for all 'A'.

Data/Example:

Column 'A' Column 'B'
A .05
D .005
Z 1.5
A .9
F .02
A .23

Solution would be A = 0.447921

So i was looking for a formula that would search for all items in column 'A' for A and total all values in column 'B' results in STD value for A. I know i can do this in two steps but i would prefer to do it in one step.

Any ideas?

 

[Dojorgen]

never mind i think i found it........{=STDEV(IF(A1:A5)="A",B1:B5))}