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...
agover17
It is possible with conditional formatting for colored cells
and otherwise with
highest 2
=MAX(A1:A100)
and
=MAX(A1:A100)-1
lowest 2
=MIN(A1:A100)
and
=MIN(A1:A100)+1