Preparation and Summarisation of data

  • Thread starter Thread starter inspir3d
  • Start date Start date
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
 
Back
Top