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...
Data = A1:A24 as an example.
If you have access to stacking functions perhaps:
=VSTACK(LARGE(data,{1,2}),SMALL(data,{1,2}))
Otherwise, you could split SMALL and LARGE into two formulas:
top 2
=LARGE(data,{1,2})
bottom 2
=SMALL(data,{1,2})