No, this isn't about EVE Online.
February 28, 2013 5:59 AM Subscribe
I need help taming a very long list of numbers into useful tabulated data, in Excel.
posted by 256 to Computers & Internet (10 answers total) 1 user marked this as a favorite
I have an Excel spreadsheet. It consists of a single column with 8,784 rows. Each cell contains a number. That number represents a data value corresponding to an hour from 2012. The data values are in order, starting at midnight Jan 1, and going to midnight Dec 31.
I need to turn this mess into a 12x24 table representing average hourly values for each month. My Excel-fu is weak.
The best way I currently know to do this is to just type a series of very long functions like: =Average(A1, A25, A49,A73 ...)
This is obviously not the right way. So, what's the right way?