| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Need totals of values that fall within a given year | Excel Worksheet Functions | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| How to sort by day and month while ignoring year? | Excel Worksheet Functions | |||
Threaded Mode
