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...
Oops, I missed you need 4 values for each date. When PivotTable possible, but perhaps not easiest variant.
If with formulae depends on your Excel version.