LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
J@Y J@Y is offline
external usenet poster
 
Posts: 127
Default Monthly Data, need quarterly Stdev

My monthly data are in a column. I am currently using B1=Stdev(A1:A3)....
then selecting 3 vertical cells (ie: B1:B3) then dragging it down. But that
leaves each quarterly Stdev 2 spaces apart. How would I do it so that the
quarterly Stdev organized in 1 spaceless column?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert monthly data into quarterly data? jetlag Excel Discussion (Misc queries) 3 April 2nd 23 08:54 PM
Data Matching Button for MS Excel 2007 or later Mr. Low Excel Worksheet Functions 0 October 21st 06 10:07 AM
Collecting weekly and monthly totals from daily data Kasper Excel Worksheet Functions 0 January 12th 06 08:02 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"