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
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]a[/TD]
[TD="width: 64, align: right"]12[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]85[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]412[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]758[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD="align: right"]52[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!