Difference between revisions of "Excel Macros"

From IARC 207 Wiki
Jump to navigation Jump to search
imported>Bob
 
imported>Bob
Line 5: Line 5:
 
* [[Calculate Daily Averages / Sums from hourly data]] (written for excel)
 
* [[Calculate Daily Averages / Sums from hourly data]] (written for excel)
 
* [[Freezing / Thawing Indices]] (written for excel)
 
* [[Freezing / Thawing Indices]] (written for excel)
 +
* [[Cell Wrap]] -- Useful for long column headers in data spreadsheets.
 +
* [[Data Split]] -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel

Revision as of 10:20, 12 March 2008

Handy Code Snippets

This page contains links to several Excel Macros that Bob's made. Feel free to use or add additional ones.