View Single Post
 
Old 02-02-2019, 07:51 AM
Intruder Intruder is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default Huge Stdev bars using if-array

Small dataset with 3 dataseries in 2 criteria (columns),
Stdev values looks absolutely errornous when using array fiunction compared to single range formulas.
1 Excel attached with 2 conditions in same tab.

Need to use array as this is part of huge dataset.
Cannot find problem
Can someone help me out please?
R
Attached Files
File Type: xlsx Test excel stdev array.xlsx (45.7 KB, 10 views)
Reply With Quote