I have a datasheet with temperatures over different depths like 1.2, 1.6, 2.1..and so on. What I would like to do is to get the average temperature in a vertical cell of 1 m, eg: layer 1-2= (1.2 1.6)/2.
Of course I know I can do this manually, but that will take alot of time. Is there a shortcut in excel or should I move on to an R programming forum?
Thanks in advance for any help!
Radiator
Last edited by radiator; 11-24-2010 at 09:01 AM.
It's easy enough in Excel. Post a workbook with some data, and show how you want the output arranged.
Entia non sunt multiplicanda sine necessitate
That sounds swell!
I have attached some of my data (and how I want it to be) unto this post. Hope it works!
Radiator
Maybe like this:
a solution with formula and Pivot table
Thank you very much!
I didn't understand how you changed the 1, 2, 3 to 1-2, 2-3, though... Could you explain how you did that?
Cheers!
Radiator
Right click on that data and Group.
I useed Auto suggestion. But you can change it to group for example by 1, 1.5, 2 etc.
Ah, thank you very much!
This case is closed :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks