Forum Discussion
Gathering two maximum and two minimum values of a data set
I have a set of data that has an entry every hour of the day, so 24 entries per day. The data set covers roughly six months. I am trying to find the greatest two values and the lowest two values of e...
Depends on Excel version and on in which form you'd like to have the result. Perhaps the easiest is to create PivotTable.