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
 
YOu can create a pivot table from the data. There are instructions and
links on Jon Peltier site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

Add Time to the Row area
Add A to the Data area
Double-click the A button, and choose to summarize by Max
Add B to the Data area
Double-click the B button, and choose to summarize by Min
 
You must log in or register to reply here.

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

Similar Threads

Preparation and Summarisation of data 3
Data grouping and averaging in excel 2003 1
Return Last 10 rows in reverse row order. 9
2007 Pivot Table 5
Finding minimum value across selected rows of an array 2
Sort by Large, Offset from Match, Duplicate values problem 2
Need some more help with a linq query or lambda expression 2
MIN, MAX, MODE tec.... from an array??? 1

Back
Top