Huge Stdev bars using if-array

		Microsoft Office Forums > Microsoft Excel > Excel
Huge Stdev bars using if-array

FAQ

Thread Tools

Display Modes

02-02-2019, 09:12 PM

xor

Windows 10 Huge Stdev bars using if-array

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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

Test excel stdev array_2.xlsx (31.4 KB, 19 views)

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:36 AM.