Finding the last value less than 24 hours

[alex_a]

Hi,

I have a list of customer names in column A of sheet 1,their product testing results in columns O, R, U, and X, and the time tests completed in column AK. I need a way to populate sheet 2, column A through F (B, C, D, E, for test results option) and F for the time test conducted with the customer name, test dates and test result( last test date less than or equal 24 hours). In column Ak of sheet ,we may have different hours of tests from1 hour to 40 hours).I need the very last value close to time 24 and its corresponding test results (pass/fail in columns O,R,U, and X).
Thanks for your help.

 

[sijpie]

Alex_a, does my code do the trick?

 

[alex_a]

This is the a numeric value (time difference). Has nothing to do with time format. What I am asking find the closest value to 24. Thanks.

 

[alex_a]

Unfortunately, your code is not producing the required result. It only finds the highest value, not the ones closest to value 24, plus when I change the values, the code won't change the outcome (old values in the population is still showing).

 

[sijpie]

Well in the examplefile you sent me the highest was also the closest to 24. The highest number was somewhere between 0.5 and 1.3. I did not see any that was closer to 24 than the highest. If I look at the last column, which is closer to 24 according to you? Why?
I asked you for an example sheet, which you sent, but as it was only showing an input table, and an empty output table, I was left to guess at what you wanted as output.

I can modify the code simply to delete the table first before dumping the new values, but I wanted to understand if what I was doing was correct, before spending a lot of time cleaning up.