Hi everyone.
I've decided to ask for some help after pulling my hair out for a couple of days :/
I have temperature data listed in column A, and a corresponding sample figure taken at that temperature in column B next door. I need to find a way to sum each sample amount at regular intervals of temperature (i.e. in 0.1 increments). The pivot table only gives increments around temperatures where positive sample numbers occur (i.e. where there is 0 sample, say at 14.2 degrees), the group field will look like this (14 - 14.1; 14.3-14.4... etc), missing the 14.2 interval completely. For the analysis I need to run, I need all temperature group intervals, not just the ones that include positive sample figures.
Can I force the pivot table to include all 0.1 increments? or is there a function I don't k ow about that might help me achieve this?
Thanks in advance
Stu
Bookmarks