How to Return Partial List of Column Values when Values in Other Columns meet a Condition

Well, I am very stumped on this one. I have been building a spreadsheet to sort through data files and it's been going ok until now. I have tried everything but to no avail.

The problem:

Basically, as will be more clear when viewing the accompanying spreadsheet, I want to collect time and H data starting when cycle=6000, displacement <0.001, but after the 6000th cycle completes. In other words, there is a brief time period before displacement ramps up and down for the last time where force<0.01 and cycle=6000. I want to start at row 258 not row 174.

Thanks a lot in advance for anyone who can help me solve this very frustrating problem. I am not a programmer, but I think it's very satisfying building spreadsheets and macros that perform repetitive analyses and tasks for you.

Best!

Dear Mike,

Please check if attached pivot table helps you... you may filter as per your requirements.

Actually not able to understand the exact requirement. There is no difference at row 258 not row 174 for cycle and Displacement.

More elaboration will help.

Regards,

Kamal

I attached a graph to show what I mean. I could do this all manually of course, but I'd like to have a formula that can auto populate some cells so I can graph them.