Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.