I
inspir3d
Hi thanks a lot. The pivot table is great. I got another proble
though.
What do I do if I want to summarise my data like so:
I have
Time C D
930 423 231
930 312 233
930 314 245
931 224 432
931 234 435
931 244 431
And I want to summarise it as
Time, C', D'
930 423 245
931 224 431
...
XYZ, (First value of C where Time is 930), (Last value of D where Tim
is XYZ)
Thanks again
though.
What do I do if I want to summarise my data like so:
I have
Time C D
930 423 231
930 312 233
930 314 245
931 224 432
931 234 435
931 244 431
And I want to summarise it as
Time, C', D'
930 423 245
931 224 431
...
XYZ, (First value of C where Time is 930), (Last value of D where Tim
is XYZ)
Thanks again