I want to get summarize information from the following sheet. I don't know how to summarize this information.
My scenario is like this.
If I input -6, I want to find my target value in this range.
If I input 70, I want to show only the following record.
So, summary is like this. I will be key-in one by one
.=
-6
70
If I hit enter, result want to display like;
865.5 70 155 4
Please help me to provide sample solution or sample function to solve this.