ATT Ali Modify your Lookup tables to add another feature

Hi Ali

It was brought to my attention tonight that I have not allowed for an entry on the OPEN Sheet,

In my sample sheet we have 2 x 40km legs, with checkpoints 1,2,3, & 4, then they return to BASE
WHAT I have NOT allowed is a column to show what time they went back out on the second leg,
or if there is a 3rd leg we need a " Time Out " column Please.


73s

Peter

I'll have a look.

Where have you shown what is required? I can't see any changes in the workbook. I need to have an idea of what this should look like.

Do you mean that we need a Time Out after each base like this:

Excel 2016 (Windows) 32 bit

	A	B
1	ChkPts	ChkPts
2	1	ChkPt 1
3	2	ChkPt 2
4	3	ChkPt 3
5	4	ChkPt 4
6	5	Base
7	6	TimeOut
8	7	ChkPt 5
9	8	ChkPt 6
10	9	ChkPt 7
11	10	ChkPt 8
12	11	Base
13	12

Sheet: Sheet1

Hi

On the current file on the OPEN sheet Columns : J and P once the added " Time Out " column is added
Is that enough info ??

Thank You

That's it exactly

In L8:

=IF(K8>MAX($J$8:$J$10),"",IF(L7="Base","TimeOut",IF(ISNA(MATCH(K8,$J$8:$J$10,0)),"ChkPt "&K8-SUM(COUNTIF(L$7:L7,{"TimeOut","Base"})),"Base")))

Drag copy down.

Hi Ali

Once again you have helped out.

Many Many Thanks

Pete

No worries.

This was posted in the VBA forum, shouldnt it be moved to General?

I didn’t notice. I’ll move it.