AgTalk Home
AgTalk Home
Search Forums | Classifieds (100) | Skins | Language
You are logged in as a guest. ( logon | register )

Excell help from the pros
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
agricon
Posted 9/16/2014 10:06 (#4077308)
Subject: Excell help from the pros


Hi everyone,

trying to sort data for corn the last 10 years by monthly avg, problem is the days per month vary so a set formula does not work, i.e. see below,

is there a formula that can adapt to each month and get avg price for the month in another set column.

Example

Code CORNYF1
2004-09-15 218.5
2004-09-16 216.25
2004-09-17 215.25
2004-09-20 212.75
2004-09-21 212.75
2004-09-22 210.25
2004-09-23 207.75
2004-09-24 205.25
2004-09-27 207.75
2004-09-28 208.5
2004-09-29 207.25
2004-09-30 205.5
2004-10-01 206
2004-10-04 202.75
2004-10-05 204.5
2004-10-06 207.25
2004-10-07 206
2004-10-08 204.5
2004-10-11 204.75
2004-10-12 202.5
2004-10-13 205.25
2004-10-14 204.25
2004-10-15 206.75
2004-10-18 204
2004-10-19 207
2004-10-20 206
2004-10-21 204.25
2004-10-22 201.75
2004-10-25 205.25
2004-10-26 206.75
2004-10-27 206.25
2004-10-28 206.25
2004-10-29 202.5
2004-11-01 200
2004-11-02 199.75
2004-11-03 199
2004-11-04 197.5
2004-11-05 199.5
2004-11-08 198
2004-11-09 198
2004-11-10 198.25
2004-11-11 197.25
2004-11-12 200
2004-11-15 202.5
2004-11-16 203
2004-11-17 205.75
2004-11-18 204
2004-11-19 199.25
2004-11-22 197.5
2004-11-23 198
2004-11-24 197.75
2004-11-25 197.75
2004-11-26 197
2004-11-29 193.25
2004-11-30 192.5
2004-12-01 191.5
2004-12-02 192.5
2004-12-03 196.25
2004-12-06 197.75
2004-12-07 193.75
2004-12-08 195.5
2004-12-09 194.75
2004-12-10 193.5
2004-12-13 197.25
2004-12-14 195
2004-12-15 205
2004-12-16 203.5
2004-12-17 204.5
2004-12-20 206.5
2004-12-21 205.75
2004-12-22 205.5
2004-12-23 207
2004-12-24 207
2004-12-27 207.5
2004-12-28 207
2004-12-29 203.25
2004-12-30 204.75
2004-12-31 204.75
2005-01-03 201.75
2005-01-04 201
2005-01-05 201.5
2005-01-06 208.75
2005-01-07 206.75
2005-01-10 206.75
2005-01-11 206.75
2005-01-12 200.5
2005-01-13 200
2005-01-14 197.25
2005-01-17 197.25
2005-01-18 196
2005-01-19 196.75
2005-01-20 197.75
2005-01-21 197
2005-01-24 197.75
2005-01-25 199
2005-01-26 198.75
2005-01-27 195.75
2005-01-28 195.75
2005-01-31 197
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)