Now, you've got to admit that the explanation in your second post is certainly more complete than the explanation in your OP. :-)
There is one part that is still confusing though.
"The kicker is that it is only when there is 10 consecutive minutes (10 rows or more) where it stays above 3 that I would want to copy."
When I look at your data, it appears that the "10 consecutive minutes" can be in either direction (up or down) from a given number.
- A3 has 9 values below it that are >3
- A17 has at least 9 numbers above it that are >3
- A13 has 1 below and at least 8 above.
Am I reading that correctly?
There is no formula that can read the list and extract the value only if it meets the "10 in a row" criteria.
It will probably needs some VBA but I want to make sure that I understand what you are looking for before I start codeing.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.