Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
180
Views
Topic starter
Hey,
I need a function of standard deviation
That you know how to take numbers for each group individually
I have run the STDEV function but it requires me to mark the numbers
And in the attachment I have 2 groups - H P
How do you automatically calculate a standard deviation for each group individually ??
(Similar to SUMIF which knows how to summarize each group separately?)
Posted : 18/02/2022 7:13 am
Hello,
Easiest solution is to use Pivot Table, see attached. If you don't want to show the Pivot Table, you can use GETPIVOTDATA to fetch the information in the table.
Br,
Anders
Posted : 18/02/2022 3:23 pm