3 ms·
=STDEV('Raw Data'!C2:C252/(1*MID('Raw Data'!A2:A252,LEN("Customer "),LEN('Raw Data'!A2:A252)-LEN("Customer ")+1))) It's an array formula which means instead of
by Xcelerate 14y ago
=STDEV('Raw Data'!C2:C252/(1*MID('Raw Data'!A2:A252,LEN("Customer "),LEN('Raw Data'!A2:A252)-LEN("Customer ")+1)))
It's an array formula which means instead of pressing ENTER, press CTRL+SHIFT+ENTER
- losethos 14y agoIt sounds like you have no idea what an operating system is. Or, you're being unusually abstract.