View Single Post
  #1   Report Post  
The Wrightster
 
Posts: n/a
Default How do I sort for the maximum values in each year in excel?

How do I sort data so I can see (sort?) the maximum value for each year in
excel. I have 365 values per year and 78 years worth of data. I got excel to
sort each year from greatest value to smallest, but now I want to sort it so
each years max value is shown first, then the next years max value, etc.