You would need extra help columns with formulas or using a filter
if you apply auto filter and select the year from the year column and then
copying the result somewhere else, then do the sorting base on the value
descending. There is now way the built in sort can handle it in one fell
swoop


--

Regards,

Peo Sjoblom


"The Wrightster" <The wrote in message
...
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.