Preparation and Summarisation of data



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

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)

Does anyone know how I can do this using excel?
Thanks a millio


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question