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.

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.

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

"Peo Sjoblom" wrote:

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.

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
DataSort and select "year" from the top list, "value" from the second list &
click OK. |:)

"The Wrightster" wrote:

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.