View Single Post
 
Old 02-02-2019, 09:12 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Attached Files
File Type: xlsx Test excel stdev array_2.xlsx (31.4 KB, 17 views)

Last edited by xor; 02-02-2019 at 11:42 PM.
Reply With Quote