Please see the attached example. The raw data are in 2 columns, and the 2nd column stores the values. I want to calculate the sample standard deviation for values that matches conditions in the 1st column. Can we do that without adding columns or sorting data? Thanks!
Need more clarity
Please consider adding a * if I helped
In cell E2, try this array formula:
Confirm as an array formula with Ctrl-Shift-Enter.
Please Login or Register to view this content.
Autofill down
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
It works well! Thanks so much!!! V
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks