Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a large amount of data for over a 20 year period that I need to sort and group. I have two columns right now, one with a date of the day the data was collected and the second with the collected data value. In some instances there were samples taken more than once a day so I have the same date multiple times in my first column. My goal is to perform an operation that would group all my data by date and report the max value for each day of data collection.

share|improve this question
up vote 2 down vote accepted

A pivot table is the tool you need. Select your data, Insert Pivot Table, put the date in the row field, put the data as a data field, then right-click the data and Subtotal by Max. This should do it.

For more info on pivot tables, check out this tutorial.

share|improve this answer
Thanks for the help, that is excatly what I used. First time using the pivot tables. Very useful! – engi_excel Oct 3 '12 at 17:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .