How do I sort for the maximum values in each year in excel?

T

The Wrightster

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.
 
P

Peo Sjoblom

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
 
T

The Wrightster

That is what I started doing, but thought maybe there was a better way and
couldn't figure it out. Thanks for the help!!!
 
C

CyberTaz

If I understand your issue, you want to sort by year and within year by
value? As long as you have the data in consecutive columns & rows (no
subtotals, no empty columns or rows, etc.) you don't need any formulas. Go to
Data>Sort and select "year" from the top list, "value" from the second list &
click OK. |:>)
 
Top