Searching for data in a matrix

[I Maycotte]

Hello everyone,

I hope someone can be of assistance in this problem:

I have an m X n matrix. I have the mean and standard deviation of this
matrix. Without writing code, how can I look through the matrix and
pull (and copy to a cell) every value above one standard deviation.

If anyone has suggestions, your help would be highly appreciated.

Thank you,


Isaac

 

[Bernard Liengme]

If you are happy with the results in a matrix form:
Let your matrix be in A15 and the mean and stdev in A7 and B7 respectively
In E1 enter =IF(ABS(A1-$A$7)>$B$7,A1,"") copy this across to H1 and down to
row 5
best wishes

 

[I Maycotte]

Hi Bernard,

Thanks for the help, but having the results in a matrix format present
a problem... a lot of empty spaces. I had in mind to have the result
printed vertically w/o the spaces. I should have been more specifi
about this on my original post; I have tried using array formulas, bu
this only produces many cells with the same value. Thanks
nonetheless.

-- Isaa