| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
STDEV of visible cells in a column
How can I write a function to calculate
standard deviation of visible cells in a column normally I wrote: STDEV (D:D) but this will calculate all cells I using office 2003 Thanks Daniel |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
STDEV of visible cells in a column
SUBTOTAL once again, look it up in help
SUBTOTAL(107,D:D) -- Regards, Peo Sjoblom "Daniel" wrote in message ... How can I write a function to calculate standard deviation of visible cells in a column normally I wrote: STDEV (D:D) but this will calculate all cells I using office 2003 Thanks Daniel |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
STDEV of visible cells in a column
Thanks Peo
"Peo Sjoblom" wrote: SUBTOTAL once again, look it up in help SUBTOTAL(107,D:D) -- Regards, Peo Sjoblom "Daniel" wrote in message ... How can I write a function to calculate standard deviation of visible cells in a column normally I wrote: STDEV (D:D) but this will calculate all cells I using office 2003 Thanks Daniel |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
STDEV of visible cells in a column
I guess some people just don't like clicking on Help, Peo. <bg
Pete On Oct 24, 11:25 pm, "Peo Sjoblom" wrote: SUBTOTAL once again, look it up in help SUBTOTAL(107,D:D) -- Regards, Peo Sjoblom "Daniel" wrote in message ... How can I write a function to calculate standard deviation of visible cells in a column normally I wrote: STDEV (D:D) but this will calculate all cells I using office 2003 Thanks Daniel- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make one column or row always visible? | Excel Discussion (Misc queries) | |||
| Sum of visible cells only | Excel Worksheet Functions | |||
| sum only visible cells | Excel Worksheet Functions | |||
| how do I sum only visible data in a column | Excel Discussion (Misc queries) | |||
| Visible cells | Excel Worksheet Functions | |||
Hybrid Mode
