# Finding the next highest value in a list

1. ## Finding the next highest value in a list

I have a list of meeting days/times and separate list of tasks with end date/times. Can someone help me to produce the formula that will match the task end date/time with the next meeting after the task is due to complete?

2. ## RE: Finding the next highest value in a list

Is the date/time in the same cell, or different cells?

"mc32" wrote:

>
> I have a list of meeting days/times and separate list of tasks with end
> date/times. Can someone help me to produce the formula that will match
> the task end date/time with the next meeting after the task is due to
> complete?
>
>
> --
> mc32
> ------------------------------------------------------------------------
> mc32's Profile: http://www.excelforum.com/member.php...o&userid=31272
>
>

3. I have it both ways

4. ## Re: Finding the next highest value in a list

Here's a proposal:

B C D E
2 meetings key date time to meeting
3 01.02.2006 14:00 01.02.2006 14:00 too early
4 12.04.2006 10:00 12.04.2006 10:00 10.04.2006 11:00
5 08.05.2006 11:30 08.05.2006 11:30 10.04.2006 11:00
6
7
8
11 13.02.2006 13:00 13.02.2006 13:00 01.02.2006 14:00
12 10.04.2006 11:00 10.04.2006 11:00 01.02.2006 14:00
13 09.05.2006 11:30 09.05.2006 11:30 08.05.2006 11:30

Formula in B4: =SUM(C4:D4) format as dd.mm.yyyy hh:mm
Copy down as required

Formula in B12: =SUM(C12:D12) format as dd.mm.yyyy hh:mm
Copy down as required

Formula in E4: =IF(ISNA(VLOOKUP(B4;\$B\$12:\$D\$14;1;TRUE));"too
early";VLOOKUP(B4;\$B\$12:\$D\$14;1;TRUE))
format as dd.mm.yyyy hh:mm
Copy down as required

Formula in E12: =IF(ISNA(VLOOKUP(B12;\$B\$4:\$D\$6;1));"too
early";VLOOKUP(B12;\$B\$4:\$D\$6;1))
format as dd.mm.yyyy hh:mm
Copy down as required

Columns C and D is your Input.

Hans

5. ## Re: Finding the next highest value in a list

Sorry,

B3:D5 and B11:D13 need to be sorted in ascending order of B

Hans

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1