|
|
#4
02-02-2019, 09:12 PM
|
|||
|
|||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Huge Mistake! | markg2 | Excel | 2 | 05-12-2014 08:05 AM |
 Convert String Array to Integer Array from a User Input?
|
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
| names on bars | Psychopig7 | Project | 1 | 06-22-2012 04:58 AM |
| STDEV minimum number of points | littlepeaks | Excel | 0 | 01-15-2012 06:40 PM |
| Tool bars gone | wasioja | Word | 1 | 05-21-2009 11:00 AM |
Windows 10 
Office 2016
Threaded Mode