STDEVA Match for large sheet.

[jespo1351]

Hello,

EXCEL 2013
is there a way to do a STDEVA with a Match function without an array? I'm looking for a formula in column C. I have a large set of data (9,000 rows, 1200+ different instances of column a) with an unknown amount of instances in column a. I want to match column A to column be to create a Standard Deviation. So if I copied all the lines down, each line for "a" will show a standard deviation of 17.41551, "b" will show 290.7066, etc...

Or if anyone knows a simpler solution to show the standard deviation for all my instances, I'm all ears.

Thank you so much
Column A Column B

a	12
a	18
a	21
a	51
a	45
b	85
b	412
b	4
b	758
b	54
b	1
b	2
c	7
c	5
c	44
d	22
d	14
d	52
d	14
d	52

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Yes that isn't too bad. That brings my list to less than 1,000 different instances. It still temporarily freezes my computer when calculating with 8 processors but its not as bad. Thanks again Aladin!

You are welcome. I assume that you do not apply the formula to whole columns.

 

[jespo1351]

No...just rows with data. I can work with this. Thanks again!