LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,670
Default Sorting data

Hello all,

I am trying to find the # of inputs per month, the mean of the total for
each month and STD of inputs for each month. Then I need to do it for all
the tests for the year.

The data runs from row 2 to row 1500 but will probably more since the end of
the year isn't here yet. My idea is to have it look something like the
following.

Month Year # of Tests 3/8"
February 08 100 99~~ mean
0.5~~Standard
Deviation

March 08 75 80
0.2

Then have at the bottom of the sheet:
year # of tests 3/8"
08 175 90~~~ Avg. of all
tests (175)
0.35~~STD of all
tests (175)

I hope this makes some kind of sense......Any help would be appreciative
Thank you in advance.
Eric

 
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
Sorting data Chris Excel Worksheet Functions 1 May 27th 08 07:04 AM
Sorting data to match existing data Jack C Excel Discussion (Misc queries) 4 May 24th 06 09:48 AM
colors of bar charted data don't follow data after sorting Frankgjr Charts and Charting in Excel 2 January 17th 06 12:33 PM
Sorting Data Henrik Excel Discussion (Misc queries) 0 September 29th 05 02:33 PM
Sorting Data vik Excel Worksheet Functions 6 September 9th 05 04:18 PM


All times are GMT +1. The time now is 08:25 AM.

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"