returning next highest time in list

Spikenaylor

Board Regular
Joined
Apr 14, 2013
Messages
115
Office Version
  1. 365
Platform
  1. Windows
I have a list of date and times which an item was entered into a fridge

the fridge has a humidity and temperature sensor, both could indicate individually that the fridge has gone out of spec and then come back in.

I have calculated a list of times the fridge is completely back in spec

I now need to show in column B for each item entered, the time the fridge has completely come back in spec.

ABCZ
Time item into fridgeTime fridge fully back in spec for this item, (what the value should be)Calculated times fridge back in spec
10:4711:0111:01
11:0611:2411:24
11:3611:5711:57
12:0312:4412:44
12:2512:4413:24
12:5213:24
13:0413:24

<tbody>
</tbody>

It is basically get the next highest time in Z for the value in A

just struggling to get it to work

I seem to just continually get one result of 12:44, when there should be two results of 12:44

any pointers greatly received
many thanks for looking
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Consider:

ABCZAA
1ABCZ
2Time item into fridgeTime fridge fully back in spec for this item, (what the value should be)0
310:4711:0111:01
411:0611:2411:24
511:3611:5711:57
612:0312:4412:44
712:2512:4413:24
812:5213:24
913:0413:24

<tbody>
</tbody>
Sheet4

Worksheet Formulas
CellFormula
B3=INDEX($Z$3:$Z$8,MATCH(A3,$Z$2:$Z$7))

<tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
That's all it takes, also notice that the 2 ranges are offset by 1 row.

Glad to help.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,217
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top