I
inspir3d
Hello I need to prepare my data and I need help
My problem is like so:
I have data like the following
Time, A, B
930 123 113
930 124 114
930 125 112
931 145 122
931 132 124
931 136 124
...etc.
And I want to arrange it into the following format:
Time, A', B'
930, (Max of A where Time = 930) , (Min of B where Time = 930)
931, (Max of A where Time = 931) , (Min of B where Time = 931)
...
XYZ , (Max of A where Time = XYZ) , (Min of B where Time = XYZ)
etc.
Does anyone know how I can do this using excel?
Thanks a millio
My problem is like so:
I have data like the following
Time, A, B
930 123 113
930 124 114
930 125 112
931 145 122
931 132 124
931 136 124
...etc.
And I want to arrange it into the following format:
Time, A', B'
930, (Max of A where Time = 930) , (Min of B where Time = 930)
931, (Max of A where Time = 931) , (Min of B where Time = 931)
...
XYZ , (Max of A where Time = XYZ) , (Min of B where Time = XYZ)
etc.
Does anyone know how I can do this using excel?
Thanks a millio