LinkBack URL
About LinkBacks
Try this.....(Since this is an Array Formula so remember to confirm it with Ctrl+Shift+Enter )
=IFERROR(STDEV(IF((Data!$A$2:$A$20=B2)+(Data!$A$2:$A$20=A2),Data!$B$2:$B$20)),"Not Enough Data")
Try this.....(Since this is an Array Formula so remember to confirm it with Ctrl+Shift+Enter )
=IFERROR(STDEV(IF((Data!$A$2:$A$20=B2)+(Data!$A$2:$A$20=A2),Data!$B$2:$B$20)),"Not Enough Data")
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks