Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
STDEV Limited Number of Arguments
Why is there a 255 argument limit for STDEV and STDEVP? My sample is quite a
bit bigger, and I need to use all of the data. There is enough swing in the first 255 that it is not representative of the whole. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
STDEV Limited Number of Arguments
nc_pinz;489682 Wrote: Why is there a 255 argument limit for STDEV and STDEVP? My sample is quite a bit bigger, and I need to use all of the data. There is enough swing in the first 255 that it is not representative of the whole. That's the limit in Excel 2007, I don't know why Each argument can be a range, you aren't limited to 255 cells. If you really need more than 255 arguments then try bracketing cells together, e.g. =STDEV((A1,B1,C1)) is only 1 argument..... -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=134992 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
confining workspace to a limited number of columns | Excel Worksheet Functions | |||
limited columns and rows number | New Users to Excel | |||
Copying over only limited number of characters | Excel Discussion (Misc queries) | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
limited number of columns | Excel Discussion (Misc queries) |