Take a look here.
If you try for example the following formula: =LEN(Z4) you will get the result 1. I don't know what you have in Z4 (and others), but try to select X4:AD12, enter 1, hold down Ctrl (to put 1 in all those cells) then delete them again, and you should see TRUE in U4:U12 and you should see other StDev's.
Why I asked about the huge dataset was because it may be a problem with array formulas.
Last edited by xor; 02-02-2019 at 11:42 PM.
|