Excel Forum

Standard deviation by group

lea cohen

Member

Members

Forum Posts: 219

Member Since:
March 10, 2016

Offline

February 17, 2022 - 9:13 pm

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?)

See Answer

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 870

Member Since:
December 7, 2016

Offline

February 18, 2022 - 5:23 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

Answers Post

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Andy Kirby, Scott Miller, Roy Lutke, Jeff Krueger, Kylara Papenfuss, Ivica Cvetkovski

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

John Chisholm

vexokeb sdfg

John Jack

Malcolm Toy

Ray-Yu Yang

George Shihadeh

Naomi Rumble

Uwe von Gostomski

Jonathan Jones

drsven

Forum Stats:

Groups: 3

Forums: 24

Topics: 6212

Posts: 27236

Member Stats:

Guest Posters: 49

Members: 31889

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen