Calculating daily values from hourly

**Snodrifter** · 12-17-2009, 06:26 PM

I need some help summarizing some data- I have hourly values for soil temperature for several months but i need daily max and min values from these- I know how to get max/min values from a single set for data but i dont want to do this for every day as it would take forever!- How can i set up a function to just do every day for me?

**teylyn** · 12-17-2009, 06:51 PM

Hi Snodrifter,

welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed, supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Snodrifter** · 12-17-2009, 07:02 PM

Ive uploaded the spreadsheet- there is hourly values for 10cm and 15 cm depth- what i need to do i get daily max and min values from this without having to set up a different function for every day (too time consuming!) Would like to set up a function where i can just copy down and save time

**teylyn** · 12-17-2009, 07:07 PM

Hi,

no need to upload 13000+ rows of data, 1000 would have been more than enough and gentler on my data plan!

This is a classical case for a pivot table. That's what they're there for. Any formula will only be more complicated and less efficient.

Learn about Pivot tables in the Excel help or start here: http://peltiertech.com/Excel/Pivots/pivotstart.htm

**DonkeyOte** · 12-18-2009, 06:38 AM

In fairness this may not be quite so trivial to setup as a standard Pivot given the Grouping requirements so...

Attached is an XL2007 example based on your data set

Note: I've removed rows beyond 1000 to keep the attachment small - simply add the data for A1001:C13231 to this file and refresh the Pivot.

**Snodrifter** · 12-18-2009, 03:15 PM

Thank you DonkeyOte! I am not too familiar with pivot tables and had no luck getting one to work but this works perfectly!
Thanks again

**MSBExcel** · 03-06-2012, 04:10 PM

Hi DonkeyOte,
I have a different set of data but I also need daily data from hourly . How did you add Years to table?
thanks

**ConneXionLost** · 03-06-2012, 11:14 PM

MSBExcel,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies. Also this thread is over two years old.