AgTalk Home
AgTalk Home
Search Forums | Classifieds (58) | 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
 
SCIN Farmer
Posted 9/16/2014 17:02 (#4077783 - in reply to #4077308)
Subject: RE: Excell help from the pros


Easiest way to do it without special macros that I can think of is to sort the information, then make a cell that is =average( select the yields that you want)

CodeCORNYF1Average
2004-09-15218.5
2004-09-16216.25
2004-09-17215.25
2004-09-20212.75
2004-09-21212.75
2004-09-22210.25
2004-09-23207.75
2004-09-24205.25
2004-09-27207.75
2004-09-28208.5
2004-09-29207.25
2004-09-30205.5210.6458333333
2004-10-01206
2004-10-04202.75
2004-10-05204.5
2004-10-06207.25
2004-10-07206
2004-10-08204.5
2004-10-11204.75
2004-10-12202.5
2004-10-13205.25
2004-10-14204.25
2004-10-15206.75
2004-10-18204
2004-10-19207
2004-10-20206
2004-10-21204.25
2004-10-22201.75
2004-10-25205.25
2004-10-26206.75
2004-10-27206.25
2004-10-28206.25
2004-10-29202.5204.9761904762
2004-11-01200
2004-11-02199.75
2004-11-03199
2004-11-04197.5
2004-11-05199.5
2004-11-08198
2004-11-09198
2004-11-10198.25
2004-11-11197.25
2004-11-12200
2004-11-15202.5
2004-11-16203
2004-11-17205.75
2004-11-18204
2004-11-19199.25
2004-11-22197.5
2004-11-23198
2004-11-24197.75
2004-11-25197.75
2004-11-26197
2004-11-29193.25
2004-11-30192.5198.8863636364
2004-12-01191.5
2004-12-02192.5
2004-12-03196.25
2004-12-06197.75
2004-12-07193.75
2004-12-08195.5
2004-12-09194.75
2004-12-10193.5
2004-12-13197.25
2004-12-14195
2004-12-15205
2004-12-16203.5
2004-12-17204.5
2004-12-20206.5
2004-12-21205.75
2004-12-22205.5
2004-12-23207
2004-12-24207
2004-12-27207.5
2004-12-28207
2004-12-29203.25
2004-12-30204.75
2004-12-31204.75200.8586956522
2005-01-03201.75
2005-01-04201
2005-01-05201.5
2005-01-06208.75
2005-01-07206.75
2005-01-10206.75
2005-01-11206.75
2005-01-12200.5
2005-01-13200
2005-01-14197.25
2005-01-17197.25
2005-01-18196
2005-01-19196.75
2005-01-20197.75
2005-01-21197
2005-01-24197.75
2005-01-25199
2005-01-26198.75
2005-01-27195.75
2005-01-28195.75
2005-01-31197199.9880952381

 

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)