Calculating Std Deviation based on a condition
 

Hi,

I have data in A2 through B100

Column A has numerical data while B has values like "A", "B" and so on.

More than one row could have the same value of B. I apply a unique
filter on column B and get the results in Cells D2 through D10. Now, In
cells E2 through E10, I want to find standard deviation of Column A
(for matching values from Column D and B)

One way can do this is using Pivot. But I want to know if I can use
some combo formula to do the same (it will be somewhat equal to Sumif
formula).

Regards,
HP
India